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).