Back to questions

SQL COUNT Practice Exercise SQL Interview Question

SQL COUNT Practice Exercise

SQL Interview Question

**Output the number of rows in the table. **

Table:

Column Name	Type
product_id	integer
units_sold	integer
total_sales	decimal
cogs	decimal
manufacturer	varchar
drug	varchar

Sample Input:

product_id	units_sold	total_sales	cogs	manufacturer	drug
9	37410	293452.54	208876.01	Eli Lilly	Zyprexa
34	94698	600997.19	521182.16	AstraZeneca	Surmontil
61	77023	500101.61	419174.97	Biogen	Varicose Relief
136	144814	1084258	1006447.73	Biogen	Burkhart
...	...	...	...	...	....

Example Output:

count
183

Difficulty

Easy

Input

Output