SQL How to Retrieve Data From a Single Table List the first name and last name of the two employees from the db1 hr employees table that were hired during the year 1987 use two different methods The resulting table should one column and have the name 'Name' at the top Queries goes here Screenshot goes here List the first name and last name of the employees from the db1 hr employees table that were NOT hired in the year 1997 The resulting table should one column and have the name 'Name' at the top List only the top 10 names returned from the query The last name should be sorted in ascending order, then sorted by the first name Queries goes here Screenshot goes here List the first name and last name of the employees from the db1 hr employees table have 'st' at the beginning of their job id The resulting table should one column and have the name 'Name' at the top List only the top 10 names returned from the query The last name should be sorted in ascending order, then sorted by the first name Queries goes here Screenshot goes here List the first name and last name of the STUDENT from the db1 hw student table that have the 3 letters 'usa' somewhere in the name of their employer The resulting table should one column and have the name 'Name' at the top Queries goes here Screenshot goes here List the title, first name, middle initial, and last name of the employee from the db1 costco employee table who's job code is 'sec' and works in the Database Corner store (store code 2) The resulting table should one column and have the name 'Name' at the top Queries goes here Screenshot goes here Examples 1 e 100 Do re Results EC Messages Name Steven King Jennifer Whalen 1 2 2 trie Results El Messages Zetrie Name 1 Ellen Abel 2 Sundar Ande 3 Hermann Baer Amit Banda N 4 5 Elizabeth Bates 6 Sarah Bell Harrison Bloom Anthony Cabrio Gerald Cambrault Nanette Cambrault 9 10 3 5 100 Results Bi Messages Name Mozhe Atkinson PHD Laura Bissot Curtis Davies como de o 6 7 Adam Fripp Ki Gee Payam Kaufling Renske Ladwig James Landry Jason Mallin Steven Markle che be 07 01 4 Chat 100 Results Name 1 John Smith 2 3 Dawn Dennis Jeffrey Citron Eric Da Silv 5 100 Results Bi Message wa Retriever etrieve Name 1 Mr Jack W Eindsmar

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 24, 2024

SQL How to Retrieve Data From a Single Table List the first name and last name of the two employees from the db1.hr.employees table that

SQL How to Retrieve Data From a Single Table

List the first name and last name of the two employees from the db1.hr.employees table that were hired during the year 1987 use two different methods. The resulting table should one column and have the name 'Name' at the top.

Queries goes here

Screenshot goes here

List the first name and last name of the employees from the db1.hr.employees table that were NOT hired in the year 1997. The resulting table should one column and have the name 'Name' at the top. List only the top 10 names returned from the query. The last name should be sorted in ascending order, then sorted by the first name.

Queries goes here

Screenshot goes here

List the first name and last name of the employees from the db1.hr.employees table have 'st' at the beginning of their job_id The resulting table should one column and have the name 'Name' at the top. List only the top 10 names returned from the query. The last name should be sorted in ascending order, then sorted by the first name.

Queries goes here

Screenshot goes here

List the first name and last name of the STUDENT from the db1.hw.student table that have the 3 letters 'usa' somewhere in the name of their employer. The resulting table should one column and have the name 'Name' at the top.

Queries goes here

Screenshot goes here

List the title, first name, middle initial, and last name of the employee from the db1.costco.employee table who's job_code is 'sec' and works in the Database Corner store (store_code 2). The resulting table should one column and have the name 'Name' at the top.

Queries goes here

Screenshot goes here

#Examples

image text in transcribed

1. e 100 % Do re Results EC Messages Name Steven King Jennifer Whalen 1 2 2. trie Results El Messages Zetrie Name 1 Ellen Abel 2 Sundar Ande 3 Hermann Baer Amit Banda N 4 5 Elizabeth Bates 6 Sarah Bell Harrison Bloom Anthony Cabrio Gerald Cambrault Nanette Cambrault 9 10 3. 5 100 % ::: Results Bi Messages Name Mozhe Atkinson PHD Laura Bissot Curtis Davies como de o 6 7 Adam Fripp Ki Gee Payam Kaufling Renske Ladwig James Landry Jason Mallin Steven Markle che be 07.01 4. Chat 100 % Results Name 1 John Smith 2 3 Dawn Dennis Jeffrey Citron Eric Da Silv 5. 100 % Results Bi Message wa Retriever etrieve Name 1 Mr. Jack W Eindsmar