Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

sQL Query Practice I The following query statements are based on Company database in class note EMPLOYER DEPT LOCATIONS WORKS ON DEPENDENT NAM RELATIONSHIP Query

image text in transcribed
sQL Query Practice I The following query statements are based on Company database in class note EMPLOYER DEPT LOCATIONS WORKS ON DEPENDENT NAM RELATIONSHIP Query 0: List the last name of male employees. Query 0-1: List the first name, middle name and last name of employees who born on December 8, 1995. Query 0-2: List the first name and last name of employees who earn $50,000 minimum salary (more than $50,000). Query 1: List the birthdate and address of the employee whose name is Tom G Brand'. Query 1-1: List the location of department no 8. Query 1-2: List the name and location of projects which department no 5 manages. Query 1-3: List the name of spouse of all employees. Query 2: Retrieve social security numbers for all employees. Query 2-1: List all different last names of employees. Query 3: List the social security numbers of all employees who work on project number 1, 2, or 3. Query 3-1: List the name and salary of employees who work for department number 4, 5, or 6. Query 4: List the names of all employees who do not have supervisors. Query 5: List all employees whose address is in Atlanta, GA. Query 6: List all employees who were born during the 1960s. (use LIKE) Query 6-1: List all employees who were born during the 1960s. (use BETWEEN AND) Query 6-2: List employees who first name is between 'Apple' and 'Bee

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual Basic.NET

Authors: Ying Bai

1st Edition

0521712351, 978-0521712354

More Books

Students also viewed these Databases questions

Question

Which form of proof do you find least persuasive? Why?

Answered: 1 week ago