a Q6. Suppose you have a table / relation Employee with attributes (Emp ID, Emp Name, Department, Hiring date, Address,

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
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,

Post by answerhappygod »

A Q6 Suppose You Have A Table Relation Employee With Attributes Emp Id Emp Name Department Hiring Date Address 1
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, 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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply