C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID - FIRST_NAME - LAST_NAME - EMAIL - PHONE_NUMBER - HIRE_DATE - JOB_ID - SALARY - COMMISSION_PCT - MANAGER_ID - DEPARTMENT_ID . COUNTRIES - COUNTRY_ID - COUNTRY_NAME -REGION_ID . CUSTOMERS - CUST_ID CUST_EMAIL CUST_FNAME CUST_LNAME CUST_ADDRESS CUST_CITY CUST_STATE_PROVINCE CUST_POSTAL_CODE CUST_COUNTRY CUST_PHONE CUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID . EMPLOYEES - EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID . JOB_HISTORY - EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMENT_ID . JOBS - JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY . LOCATIONS - LOCATION_ID STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE COUNTRY_ID . REGIONS - REGION_ID REGION_NAME . SAL_GRADES - GRADE_LEVEL LOWEST_SAL HIGHEST_SAL . SALES - SALES_ID SALES_TIMESTAMP SALES_AMT SALES_CUST_ID SALES_REP_ID

Q: What did each card cost? Show the card number, player last name, team name, price, price with 5%…

A:

Q: List the years and their total gross earnings (sum of earnings per year), but do not include gross…

A: ANSWER:-

Q: Show students’ first name, last name, the grades of the students, and the credits of the course for…

A: Select St.FristName, St.LastName, Et.Grade, C.CourseIDfrom Student St INNER JOIN Enrollment Et ON…

Q: List all book titles that have never been borrowed by any borrower.

A: The SQL program for the given problem is as follows: use demo;Create table Book(ISBN varchar(30) Not…

Q: Find the rep number, last name, and first name of each sales rep who represents at least one…

A: The, answer has given below:

Q: Display employees where the first name or last name starts with S. using sql plus hr user

A: To select data from a database,  SELECT statement are used. The data is saved in a result table…

Q: List the job title and maximum salary which the salaries are between $10,000 and $20,000. Use…

A: The objective of the question is to retrieve the job title and maximum salary from a database where…

Q: Find the temperature in increasing order of all cities a) SELECT city FROM weather ORDER BY…

A: Question. Find the temperature in increasing order of all cities SELECT city FROM weather ORDER BY…

Q: In how many ways can a 16-person club select a president, vice-president, and secretary from among…

A: There are 16 people to choose.in that 3 distinct persons to be selected.

Q: Design a query of Stores with the following: Store Name, Store Size, Sum of order amounts,  Percent…

A: JOIN Based on a common column between two or more tables, a JOIN clause is used to merge rows from…

Q: Create the following table in your database with the following schema: Table: Users I Column Name 1…

A: We need to provide sql query codes  for the given database schema

Q: Write the SQL queries for the following questions and show results. List all the section numbers of…

A: In the structured query language, the query consists of the three clauses that are used to retrieve…

Q: Show all female’s first names and their salary.  Show the branchno that has a supervisor whose…

A: Relational database is a type of database which stores and provides the access to data which are…

Q: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name,…

A: Hi there, Please find your solution below, I hope you would find my solution useful and helpful.…

Q: 4. b. C. Create the following queries: List the names of places from which the company sells. Show…

A: The database contents are not mentionedThe generalized query can be written asSelect * from…

Q: Part II: Complete the following exercise:    Using a subquery, select student first name where the…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: Find the listing of customers who did not make purchases during the invoicing period. Sort the…

A: SQL: SQL (Structured Query Language) is a programming language used to manage and manipulate data in…

Q: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

A: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

Q: ServiceCategory CategoryNum CategoryDescription 1 Plumbing 2 Heating/Air Conditioning 3 Painting 4…

A: The query to List the location number and unit number for every condo whose square footage is equal…

Q: Display CustomerName and Status as 'Q2 for every customer who was born during the 2nd quarter of…

A: The given problem is related to database SQL query. The problem has provided the msCustomer table…

Q: Product a report showing the distinct first and last names of customers from the state of New York…

A: In the Database , a SQL query which refers to the one it is a request for data from a database. SQL…