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  

---

Is sql a case sensitive language?

0 Answers  

---

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

---

How many scalar data types are supported in pl/sql?

0 Answers  

---

---

What is sqlerrd?

0 Answers  

---

What is materialised View?

2 Answers   IBM,

---

What is the maximum database size for sql express?

0 Answers  

---

what is inline command?

2 Answers  

---

What is an intersect?

0 Answers  

---

What are the different types of sql commands?

0 Answers  

---

What is a delimiter in sas?

0 Answers  

---