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
Q2. (20 points)Repeat Q1 for the same output without using variables and a script but only onesingle SELECT statement with subqueries.