- A Q6 Suppose You Have A Table Relation Employee With Attributes Emp Id Emp Name Department Hiring Date Address 1 (32.62 KiB) Viewed 39 times
a Q6. Suppose you have a table / relation Employee with attributes (Emp ID, Emp Name, Department, Hiring date, Address,
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
a Q6. Suppose you have a table / relation Employee with attributes (Emp ID, Emp Name, Department, Hiring date, Address,
a Q6. Suppose you have a table / relation Employee with attributes (Emp ID, Emp Name, Department, Hiring date, Address, City). Write the SQL queries for the following: (a). Write a select query to show the records of the employee hiring date from 01- 01-2010 to 30/12/2020. (10 points) (b). Write a select query to show the records of the employee whose country is Kuwait and UAE. (10 points) (c). Write a select query to show the records where cities are (London, Liverpool, Leads) and group the records as per employee departments. (10 points)