Member Avatar for lovely_girl1989

http://www.picturebang.com/images/331323386942

Hi to all,
this the first post in the forum and i have some of questions need to be made in SQL Statements..
i tried to answer some of them and the other i don't how to make it.. so plz help me becauze i'm a new in SQL language.. ASAP..
i will apprciate your efforts ..
these are the question:
1)List the customers who shopped at the store the first seven days in June.

2)What was the most expensive item sold in July?

3)What was the most expensive item sold in July?

4)List the cats that are brown and cost less than $300, or any brown female animal
priced less than $150.

5)Which employee placed the most expensive order in August?

6)Did the store sell more cats or dogs in the first quarter?

7)List the products with a list price greater than the average list price of all
products.

8)List the cats that took longer than average cats to sell.

9)Which merchandise items with more than 100 units on hand have not been ordered in 2004? Use a sub query to answer the question.

  • 3 Contributors
  • 2 Replies
  • 141 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for vuyiswamb

You need to Buy a Book learn Before you answer these Question, it is Clear that you did not attempt to buy a book.

We dont do homeworks for People Buy a Book

Member Avatar for Ramy Mahrous

Yes you need some tutorial in T-SQL as said, please contact me to provide you with some books.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.