Back to questions
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 |
Solution
SELECT COUNT(*) FROM pharmacy_sales;
PostgreSQL 14