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: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer :--  Jan-12-01

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: Q2: Do these queries: 1. Show department name and instructor name who is having salary greater than…

A: Due to company policies I am compelled to solve only one question and that is the first question.…

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: Show all name and phone numbers of students and the type of donation they received including any…

A: Show all name and phone numbers of students and the type of donation they received including any…

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: Write SQL code that will return the total number of hours worked for each employee and the total…

A: SQL code: The COUNT function calculates the number of numeric values in a list of inputs. COUNT…

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: Write SQL code that will return the total number of hours worked for each employee and the total…

A: Assignment: An assignment is a task that you have been given by someone in authority. The term…

Q: select first name of customer  and the highest total in invoice in sql

A: The highest of any column can be obtained by using max operator select is used to display the data

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: There are 9 workers for ASH Development Sdn. Bhd. as shown in Table Q4. Unfortunately, there are…

A: According to question there are 9 workers and 4 rooms. The Ids of workers selected for the jobs are…

Q: Select FirstName,LastName,department,project_name,hours from employeetab,Project where…

A: This SQL code aims to select certain columns from two tables, employeetab and Project, join them…

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: Use SQL to write the following queries: a) Find the last names of students born after January 1,…

A: In this question we have to understand about the given SQL queries and suggest if these queries are…

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: 1. Display detail of all employees from Employee table. Answer: 2. Display name of employees, who…

A: The first three parts will be answered 1 To select all records from a table, SELECT along with *…

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: (Consider table employees with the following colunms (EMPLOYEE ID, FIRST NAME, LAST_NAME , EMAIL…

A: Select CONCAT(M.First_Name,' ', M.Last_Name) as MANAGER_NAME , M.Department_ID from Employees E…

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…