Online Course Support

Here is the default.orders table: order_id cust_id empl_id total 1 c 1 24.78 2 a 4 28.54 3 b 3 48.69 4 b 3 -16.39 5 z 2 29.92 How many columns and rows does the result of this query have?

Question 4
Here is the default.orders table:

order_id cust_id empl_id total
1 c 1 24.78
2 a 4 28.54
3 b 3 48.69
4 b 3 -16.39
5 z 2 29.92
How many columns and rows does the result of this query have?

SELECT cust_id, COUNT(*), SUM(total)

FROM default.orders

GROUP BY cust_id;

1 point

2 columns, 1 row

2 columns, 4 rows

2 columns, 5 rows

3 columns, 1 row

3 columns, 4 rows

3 columns, 5 rows

4 columns, 1 row

4 columns, 4 rows

4 columns, 5 rows

6 columns, 1 row

6 columns, 4 rows

6 columns, 5 rows

Similar Posts