Assume that the personnel table contains three records of employees with these first and last names: Peter Jones Mary Jones Robert Johnson How would these three records be ordered in the result set of the following query? SELECT firstName, lastName from personnel ORDER BY lastName, firstName Select one: O a. O b. 0 с. O d. Mary Jones, then Peter Jones, then Robert Johnson Mary Jones, then Robert Johnson, then Peter Jones Peter Jones, then Mary Jones, then Robert Johnson Robert Johnson, then Mary Jones, then Peter Jones

Assume that the personnel table contains three records of employees with these first and last names: Peter Jones Mary Jones Robert Johnson How would these three records be ordered in the result set of the following query? SELECT firstName, lastName from personnel ORDER BY lastName, firstName Select one: O a. O b. 0 с. O d. Mary Jones, then Peter Jones, then Robert Johnson Mary Jones, then Robert Johnson, then Peter Jones Peter Jones, then Mary Jones, then Robert Johnson Robert Johnson, then Mary Jones, then Peter Jones

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Question 6 Consider the following table schema: CREATE TABLE members( member_id INT, first_name…

A: To Do: We need to identify the column for indexing.

Q: on to your da

A: Step1: Let's make a column called EmailAddress in the Contacts database. We'll populate the table…

Q: Create entity named schedule with attributes schedule_code as characters with size 15, course_code…

A: Query to create the table is: Create table Schedule ( schedule_code varchar(15), course_code…

Q: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

A: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

Q: DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID 10 Administration 200 1700 Marketing 201 1800…

A: According to the asked question, the solution is given below with a proper explanation.

Q: Write a sql query to create the given table.

Q: reate a query in query design view based on both tables to answer the question, What is the concert…

A: Query: Create query: CREATE TABLE `sponsor`( `concert_id` INT(50), `sponsor_name` VARCHAR(50),…

Q: Task 18: List the item ID, description, unit price, and category for each item that has a unit price…

A: Task 18: ALL Operator: The operator is used with WHERE or HAVING clause. If ALL operator is used in…

Q: Please write the MySQL query for the following task: Find the first_name, last_name, employee_id,…

A: we can use the following MySQL query:

Q: Which clause can be used to restrict or filter the groups returned by a group function- based query?

A: The HAVING Clause is used to filter data from groups depending on a condition that is specified in…

Q: Question 18 The query in the figure below: BRANCH SALESPERSON 1 Dr ID Br. Name 1Em ID TITLE FIRST…

A: - We need the right show option for the table shown. - From the diagram and the table it is clear…

Q: Create a query that lists empno, projno, emptime, emendate. Left join the project to the empprojact…

A: Below i have written the query:

Q: Form 1 Title: The Joy of E-R Modelling Published_In 2013 ISBN: 939757 Author Id: AU505 Author Name :…

A: We use the primary key and foriegn key concept of the database to create the tables and join between…

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: Suppose you wish to see the employee name and salaries of the employees whose salary is greater than…

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

Q: e DEPARTMENTS table has the following data: DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID 10…

A: Here all the tuple of column Manger_id will be selected. Order by clause will arrange the ids in…

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Correct Answer

VIEW

Explanation

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Write a query to show all record of job-history of those employees whose department number 60? SELECT first_name from employees where first_name like ‘S%’; SELECT first_name from employees where first_name like ‘_e%’; table Name :- EMP EDIT EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7839 KING PRESIDENT - 11/17/1981 5000 - 10 7698 BLAKE MANAGER 7839 05/01/1981 2850 - 30 7782 CLARK MANAGER 7839 06/09/1981 2450 - 10 7566 JONES MANAGER 7839 04/02/1981 2975 - 20 7788 SCOTT ANALYST 7566 12/09/1982 3000 - 20 7902 FORD ANALYST 7566 12/03/1981 3000 - 20 7369 SMITH CLERK 7902 12/17/1980 800 - 20 7499 ALLEN SALESMAN 7698 02/20/1981 1600 300 30 7521 WARD SALESMAN 7698 02/22/1981 1250 500 30 7654 MARTIN SALESMAN 7698 09/28/1981 1250 1400 30 7844 TURNER SALESMAN 7698 09/08/1981 1500 0 30 7876 ADAMS CLERK 7788 01/12/1983 1100 - 20 7900 JAMES CLERK 7698 12/03/1981 950 - 30 7934 MILLER CLERK 7782 01/23/1982 1300 - 10
Some rows of the table STUDENT are shown below: CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI 3.1 1992 938 MICHELE PHY 2.3 1992 931 JHON MD 3.3 2001 182 JOE MD 3.4 2002 190 REY PHY 2.0 2001 330 RON PSI 3.9 2001 You want the name all departments that have a department GPA average of 2004 greater than the global GPA average. Which query gives you the desired result? a. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT); b. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 AND AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT) GROUP BY DEPARTMENT; c. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT GPA FROM STUDENT GROUP BY DEPARTMENT); d. SELECT * FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT);
Create a view, using JOBS, DEPARTMENTS, and JOB_HISTORY tables that will include department name (not ID), job title (not jobID), start date, and end date for all rows in the JOB_HISTORY table Using your view, write a query that shows the number of rows (count) for each department. Write a query that uses your view from above to select the columns department name, job title, and end date for all rows where the department name includes the string “Sale” that is NOT case-sensitive. Use a function. i.e. SALE, SaLe, Sale, sAle, etc. should all match a row
Write a query to display the name of the department that has the maximum staff count order by department name. Refer the below schema diagram: College Management System(CMS) Department Student department id number-- PK department_name varchar(30) department_block_number number O4student_id number --> PK student_name varchar(30) address varchar(40) city varchar(30) department_id number --> FK PK-- Primary Key FK-- Foreign Key Subject Staff subject_id number -PK subject_name varchar(30) subject_code varchar(10) staff_id number -- FK staff_id number --> PK staff_name varchar(30) 王 department_id number--> FK Mark value number subject_id number--> PK,FK + student_id number-->PK,FK 王