0 votes
2.8k views
in General by (35.7k points)
closed by

Carefully observe the following table named ‘stock’: 

Table: stock

Write SQL queries for the following: 

(a) To display the records in decreasing order of price. 

(b) To display category and category wise total quantities of products. 

(c) To display the category and its average price. 

(d) To display category and category wise highest price of the products.

1 Answer

+1 vote
by (36.0k points)
selected by
 
Best answer

(a) select * from stock order by price desc; 

(b) select category, sum(qty) from stock group by category; 

(c) select category,avg(price) from stock group by category; 

(d) select category, max(price) from stock group by category;

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...