Student Sid SFname SLname DOB Marks Specialization CourselD s101 Asra Hamed 2/3/2000 85 Human Resource HR11 S102 Alia Said 3/4/2001 60 Human Resource HR12 S103 Omer Khalid 5/1/2001 72 Marketing MKT11 S104 Huda Saif 4/7/1999 63 Marketing MKT11 S105 Hamed Ahmed 3/5/2002 65 Human Resource HR11 S106 Omer Salim 4/5/2002 78 Accounting АСС11

Q: Create a query for displaying average commission percentage company is giving to its employees.…

A: Format of Query :- SELECT AVG ( coloum name ) AS aliasname FROM tablename; According To question :-…

Q: Use a query to compute the total of all purchases, the number of purchases, and the average purchase…

A: SQL query  The Round() function is used to round off the number to the desired decimal places. The…

Q: Write the SQL code that counts the number of assignments ordered for each project. Call this…

A: We have four tables namely: JOB PROJECT EMPLOYEE ASSIGNMENT We wish to write a query that counts…

Q: Write a query to display the book number, title, and replacement cost for all books in the…

A: Query to display the book number, title , and replacement cost for all books in the "Database"…

Q: How many join conditions are needed for a query that joins five tables?

A: Join: In the SQL a join clause is used to combine the data of two or more tables based on a common…

Q: Create a query to find the balance characteristics for all customers, including the total of the…

A: We can calculate the balances of table based on some grouping columns. If no grouping column is…

Q: Write a query to display the average number of days a book is kept during a checkout (Figure…

A: Solution:   Given, Schema structure is-

Q: Write query to find the balance characteristics for all customers, including the total of the…

A: Find the balance characteristics of all customers including the total of the outstanding balances.…

Q: Create a query that SELECT all of the EMPLOYEES from the EMPLOYEE TABLE that are Mangers.   Include…

A: Self Join:   A self join occurs when a table is linked to itself (also known as Unary…

Q: Write a query to display the manager name, department name, department phone number, employee name,…

A: A detailed SQL query has been created in order to retrieve particular information about a sales…

Q: Write a query to display the rental number, rental date, movie title, and detail fee for each movie…

A: According to the given schema, first create a table Movies and insert some records in the table.…

Q: department_id from employees table. Instead of displaying department_id display the related…

A: Create a query for displaying emp_id,first_name,last_name,department_id from employees table.…

Q: Display the employee's record who were hired on a specific date. The hiredate is entered by user run…

A: SQL is a structured query language, that's used to extract and manipulate the data from the table.…

Q: Create a query for displaying minimum salary in column alias “Minimum Salary” along with job_id…

A: Format of query :-  SELECT colounname ,  MIN( coloumname) AS aliasname FROM tablename;   According…

Q: Use Column level constraint setting while designing the below given table in sql named as…

A: Column constraints: In Structured Query Language, the column level constraints are used to specify…

Q: Question 4 Write a query to display the first name concatenated with the last name as Full Name, and…

A: This particular question belongs to Computer Science and Engineering. Computer Science is an…

Q: Create a query for each of the following, save and print a copy: Books on a loan, using only…

A: It is based on the Relational Database Management System(RDBMS) having executed through…

Q: What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM…

A: The query selects the result of the expression 2*(Balance - Payment) for each row in the "Customer"…

Q: Write a query that uses INNER JOIN TO connect the EMPLOYEE, EMPPROJACT, PROJACT and PROJECT tables.…

A: The INNER JOIN is also referred as EQUIJOIN.The EQUIJOIN creates a new result table by combining…

Q: Write a Query to display odd records from student table?

A:

Q: Create a query for displaying all data of employees who have joined company before 14-JUL-03 OR…

A: Lets see the solution.

Q: s. Display the employee name and department number of all employees in departments 10 and 30 in…

A: The SQL queries are given below with output screenshot Demo data has been inserted into the table

Q: Write a query to list the book title, checkout date, checkout due date and checkout in date for each…

A: According to the information given:- We have to write a query on the basic of mention need.