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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!