SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

How to combine two stored procedures in sql?

0 Answers  

---

Is sql a microsoft product?

0 Answers  

---

Does mysql support pl sql?

0 Answers  

---

How to remove duplicate rows from a table?.

3 Answers  

---

What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

what is foreign key? : Sql dba

0 Answers  

---

Is record in oracle pl sql?

0 Answers  

---

Explain the uses of a database trigger?

0 Answers  

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

How does sql profiler work?

0 Answers  

---

Are dml statements autocommit?

0 Answers  

---