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