a) List all employees in alphabetical order of surname and within surname, first name. b) List all the details of employees who are female. c) List the names and addresses of all employees who are Managers.

Q: display all fields in the JOB table sorted by the largest hourly charges for the job first

A: SELECT * will fetch you all record in table

Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…

A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…

Q: Q6) how much is the total customer balance ? Q7) what is the minimum price for each sale code?

A: SQL QUERY:  Select SUM(CUS_BALANCCE) AS [Sum of Balance] From Customer  Group by CUS_CODE.

Q: Q24) ?What product(s) have a price equal to the maximum product price Q25) List all employees with…

A: A relational database contains tables. Tables are also called relations and they contain rows and…

Q: 1. Use the following table to answer the questions below. Table name: Products Column Role Data Type…

A: We have to extract year from the Date filed and then the year has to be 2021  Now, we have to count…

Q: 7. For each project, display project name, project platform, project cost and total number of…

A: In sql, we use SELECT statement to display the table details according to the requirement. We will…

Q: The HR department needs a report to display employee information as shown from the job_history…

A: SOLUTION- With using DATEDIFF - Below is the SQL query that you could use to generate the report:…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: List the names and number of employees supervised (label this value HeadCount) for each supervisor…

A: List  the  nаmes  аnd  number  оf  emрlоyees  suрervised  (lаbel  this  vаlue  HeаdСоunt)  fоr  eасh…

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: i). List the names of all the authors in the database, and beside each name give the number of books…

A: The SQL query is given below  We have used INNER JOIN here.

Q: Q9) find the least expensive price Q10) List the UNIQUE v_code of vendors that provide products Q11)…

A: A relational database contains tables. Tables are also known as relations and they contain tuples…

Q: List the department name and its instructor’s average salary in which the instructors teach a course…

A: SQL implements WHERE clause with SELECT command in order to retrieve stored information from the…

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: List details of all customers from Canberra that have enrolled in a course order by Customer Number.

A: Answer

Q: For each different job_id group in the employee table, show the average salary and job_id for the…

A: SELECT Average_salary,              Job_id  FROM employees  WHERE EXISTS (SELECT *…

Q: List the department name, manager id and location id of all the departments that location id is 2500…

A: SELECT department_name, manager_id, location_id FROM departments where manager_id=124 ||…

Q: Using the AND or OR statement, filter the employee table for employees who live in the city…

A: The statement given,  We have to use AND or OR operator to get the employees who live in the city…

Q: Find all manager names and all the employees each manager supervises

A: The given sample table has EMPNO as the primary key and MGR a foreign key which is refereing to same…

Q: a) Your task is to write a SQL query to find count of employee who does not have a manager in the…

A: SQL query output is given in step2.

Q: The following fields are presented in the table: Member Last Name, MemberFirstName, Street, City,…

A: Information provided: MemberLastName, MemberFirstName, Street, City, State, ZipCode, and…

Q: Display manager ID and number of employees managed by the manager. using sql plus hr user

A: Display manager ID and number of employees managed bythe manager. using sql plus hr user

Q: a) Write in SQL a command that creates the table Products according to the above description (2…

A: Introduction: The syntax to create a table is shown below. CREATE TABLE table_name (    column1…

Q: Display the name of supplier(s) that supplied the most expensive computer?

A: we can't directly use aggregate functions in where clause. writing select columnName from tableName…

Q: list the last name and salary of employees who earn between $5,000 and $12,000, and are in…

A: list the last name and salary of employees who earn between $5,000 and $12,000, and are in…

Q: List the name of each department, and its total number of employees, and the total amount of…

A: Query:select dept.deptno, dname, sum(sal), count(empno) from emp  right outer join  dept on…

Q: Display the salesperson name, product finish, and total quantity sold (label as TotSales) for each…

A: In this answer I have provided the SQL code.

Q: Select all the staff full names with the customer full names of the consignments they have worked…

A: Hey there , I am writing the required SQL query for the above mentioned question. Please do find the…

Q: display the first and last names, hire dates, and number of years employed for all employees who…

A: ORDER BY is the keyword used to sort the list and to make it in descending order, we use DESC…

Basic SQL Queries

Structured Query Language is the full form of SQL. It is a high-level language used to communicate with a relational database. It is used for creating, storing and accessing contents of a relational database. SQL is used to write the queries which are executed using database engines like Oracle, SQL Server and so forth.