Q1. (20 points)
Between the ‘use’ and ‘go’, write a T-SQL script without using any subqueries to
display total number of rows of all three tables of ClearWater database, including
Categories, Products, and Suppliers. Your output should print
Total rows of Categories, Products, and Suppliers = xxxxxxx
use [ClearWater]
go
Q2. (20 points)
Repeat Q1 for the same output without using variables and a script but only one
single SELECT statement with subqueries.
use [ClearWater]
