[Solved] Assignment 12 (Chapter 14 T-SQL Scripting, 40 points)

Q1. (20 points)Between the ‘use’ and ‘go’, write a T-SQL script without using any subqueries todisplay total number of rows of all three tables of ClearWater database, includingCategories, 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 onesingle SELECT statement with subqueries.

use [ClearWater]