Question: Note: Attempt all questions. 1. No. 1 Write relevant SQL commands and calculate Attribute Affinity Matrix by Frequency Attribute Matrix. 2. Display the last name,

Note: Attempt all questions. 1. No. 1 Write relevant SQL commands and calculate Attribute Affinity Matrix by Frequency Attribute Matrix. 2. Display the last name, salary, and commission for all employees whose commission amount is 20%. 3. Display the last name, job, and salary for all employees whose job is sales representative or stock clerk and whose salary is not equal to $2,500, $3,500, or $7,000. 4. Write a query that displays the employee's last names with the first letter capitalized and all other letters lowercase, and the length of the names, for all employees whose name starts with J, A, or M. 5. Create a query to display the name and hire date of any employee hired after employee Davies
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
