Page 1 of 1
a Q6. Suppose you have a table / relation Employee with attributes (Emp ID, Emp Name, Department, Hiring date, Address,
Posted: Fri May 20, 2022 10:12 am
by answerhappygod
- A Q6 Suppose You Have A Table Relation Employee With Attributes Emp Id Emp Name Department Hiring Date Address 1 (32.62 KiB) Viewed 42 times
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)