Download as:
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Language:EN
Pages: 4
Words: 235

Discuss the logic that explains what this query does and why you created

Write one SQL Query that uses the commands OR, AND, IN, Substring, CASE, and LIKE. Discuss the logic that explains what this query does and why you created it. (Output shows Alias). 

Answer: select SUBSTRING(emp_fname,1,8) as first_name, emp_lname,

from employees where emp_city in ('Tempe') and emp_gender LIKE 'f%' or emp_salary >'$14000'

Logic: The above query extracts first eight letters of employee first name by using SUBSTRING, extract last name of employee and also extract employee marriage status using CASE for (single, married and head of household). Thee where condition extract only those employees whose cities IN ('Tempe') AND and emp_gender LIKE 'F%' OR emp_salary >$14000

Sara Sanderson MARRIED

Renee Raleigh MARRIED

Mario Vasquez MARRIED

Othello Oppenheimer MARRIED

Write one SQL Query to calculate the minimum salaries for Employees by Job Title. (Output shows Alias).

Copyright © 2009-2023 UrgentHomework.com, All right reserved.