Assignment 12 (Chapter 14 T-SQL Scripting, 40 Points) Solution

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]

END