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 NameType
product_idinteger
units_soldinteger
total_salesdecimal
cogsdecimal
manufacturervarchar
drugvarchar

Sample Input:

product_idunits_soldtotal_salescogsmanufacturerdrug
937410293452.54208876.01Eli LillyZyprexa
3494698600997.19521182.16AstraZenecaSurmontil
6177023500101.61419174.97BiogenVaricose Relief
13614481410842581006447.73BiogenBurkhart
...................

Example Output:

count
183

Difficulty

Easy

Input

(PostgreSQL)

Output