Write a query to get the number of different types of jobs available in the university table.    Write a query to get all unique first names that start with the letter S from the employees table.  Output the names in all upper case. Sort the results in ascending order.

Q: BOOK_NUM Times Checked Out BOOK_NUM TIMES Checked Out 5236 12 5236 12 No under score line 5235 5235…

A: SELECT  BOOK_NUM, COUNT(check_out_DATE) AS "Times Checked Out " FROM  CHECKOUT GROUP BY BOOK_NUM…

Q: Write a query to list the first name and last name of all authors. Concatenate the first and last…

A: The SQL query is: SELECT CONCAT(CONCAT(firstname,' '),lastname) AS FullName FROM author;…

Q: Write a query to find the third-highest bonus from the Employee table. Write a query to retrive the…

A:

Q: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: Write SQL CODE to add a new column called “Student_Nationality” in the Student table, using datatype…

A: GIVEN: Write SQL CODE to add a new column called “Student_Nationality” in the Student table, using…

Q: Write the T-SQL scripts for the following tasks:   Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Write a query which set the following constraints in Customers table (in MySQL). First Name and…

A: We are going to add constraints to the columns in the table Customers. First we will add constraint…

Q: A)  Write a query which shows the employee IDs that are unique to the employee table. Order the…

A: Solution A) -  In the first part, we need to write a query to employee Ids and the employee should…

Q: ind all the Nobel laureates, with the year of the award, who were born either in Poland (present but…

A: The query is needed to supplied in SQL.

Q: Using the tables below Now create a query, which will show the equipment rented out with status. You…

A: NOTE:- There were some mistakes in create table command, I have corrected that .      CREATE TABLE…

Q: n SQL When you use ALTER TABLE to add a column, the new column: Select one: a. Will not be created…

A: ANSWER : B   Becomes the last column in the table

Q: Write a query to print the names of all FaceX members who were born in the year 1985. .

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

Q: Create a query for selecting Employee_Id , First_Name, Phone_Number where Department_ID is not in…

A: Create table and insert data into it  CREATE TABLE EmpDetails(  Employee_Id INT PRIMARY KEY ,…

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name "geeta…

A: Question Breakdown: According to the problem statement provided we should upgrade the SQL query to…

Q: Write a query to display the current salary for each employee in department 300. Assume that only…

A: We must take into account the compensation history kept in the figure 48 table in order to get the…

Q: inventory, i.e. the sum of all products on hand for each brand id. Sort the output by brand id in…

A: Here have to determine sql query for given problem.

Q: Write a SELECT statement that returns two columns based on the EMPLOYEES table. Contact, is the…

A: SELECT CONCAT(LastName," ",substring(FirstName,1,1)) as CONTACT, HomePhone as Phone FROM EMPLOYEES…

Q: Display the last name, salary, and commission for all employees who earn commissions. Sort data in…

A: In the above question, needs to find out only those employee's last name, salary, and commission who…

Q: Write a query that will group identical movie categories together. The table name is Movies.

A: Creating table movies:   Table name- movies

Q: What's the easiest way to retrieve all the rows of a table with a query?

A: 1) If we have table and we want to retrieve all rows of data, we can use we can use the wild card *…

Q: Use multiple-row subquery in a WHERE clause. List order numbers of books, written by an author whose…

A: Multiрle-rоw  subqueries  аre  nested  queries  thаt  саn  return  mоre  thаn  оne  rоw  оf  results…

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

A: