2. INFO 3560 Database Systems Show employees whose either first name equals to S

Question

2. INFO 3560 Database Systems Show employees whose either first name equals to Smith or last name equals to Smith. (10 points) Assignment 1 (Chapter 2) 3. Show country names of which Region_ID is 1, 2, or 4 (You should use IN Operator). (10 points) The common requirements of all questions are the same. Read each question carefully and submit an appropriate query to fulfll for each question. Also, students need to provide screenshot s) of the query result under the conresponding query. The query result should be copied and pasted as it is printed on the screen without any modification. If necessary, the column names appearing in the result should be converted appropriately usng "AS" in statement Don't delete or change questions, You just need to insert both your TEXT query and captured screenshot result under your query 4. Shows employees whose last name ends with s. (10 points) Example Question 5. Shows employees whose first name starts with E. (5 points) Show all departments Example Answer Query SELECT* FROM departments; 6. Shows job titles which contain 'Manager' (10 points) SELECT YRON departments; Query Result x 01 SQL I AURONS Fetched: 27in0.007 Seconds DEPARTMENTID DEPARTMENT NAME MANAGER-ID | 200 201 114 203 121 103 204 145 100 LOCATION-1D 1700 1800 1700 2400 1500 1400 2700 2500 1700 - 10 Adninistration 20 Marketing 30 Purchasing 40 Human Resources 50 Shipping 60 IT 70 Fublic Relations 0 Sales 90 Executive 1. Retrieve all employees from Employees table. (5 points) SELECT *FROM employees

Explanation / Answer

//To Answer the question exactly table structure of all the table required

1. IT will print all of the data in the employees table.

2. Select * from employees where first_name='Smith' or last_name='Smith'

3. Select Country_Name from Country where Region_ID IN(1,2,4)

4. Select * from employees where last_name like '%s'

5. Select * from employees where last_name like 'E%'

6.  Select Job_Titles from employees where last_name like '%Manager%'

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.