ask $225$ Marks

$1)$ Key in appropriate records for all the tables. $($Sample$,$ take from the project report given and

add further meaningful records in the derived tables. Note: Minimum $20$ records in Employee

table and other tables any number of records$)$

$2)$ Display Employee Name belongs to department either IT or Finance

$3)$ Count No of Employees whose Hourly rate above $50$

$4)$ Find employee names starts with $$S$$

$5)$ Display Department Name and Sum of Hourly Rate for each Department.

Sample Output:

Department Name Total Hourly Rate

Finance $$125$

HR $$110$

IT $$175$

$6)$ Display department name with Number of employees less than $5$ Numbers

$7)$ Display Employee name and Department name, who has maximum and minimum salary

$8)$ Display No of employees $,$ Department name in each department.

$9)$ Create a procedure to display Employee Name and Department Name whose Hourly

rate is above $100.$

$10)$ Demonstration of Task$1$ and Task $2$ for $5$ minutes by Lesson $9/$ Lesson$10$ in class.

Note: Use SQL software, Do Joins in query wherever applicable. All the tables with data and S