Need help writing SQL statements for these, I'm having trouble with my returns. Explanation would help a lot. 1) Write a SELECT statement that returns the LastName and FirstName columns fromthe Students table, along with a count of the number of courses each student is takingfrom the StudentCourses table.Return one row for each student who is taking more than one class. To do that, use asubquery with the IN class that groups the student course by StudentID.Group and sort the result set by the LastName and then by the FirstName.2) Write a SELECT statement that returns the LastName, FirstName, and AnnualSalarycolumns of each instructor that has a unique annual salary. In other words, don'tinclude instructors that have the same annual salary as another instructor.Sort the results by LastName and then by FirstName.

Let's tackle each of the SQL tasks one at a time: 1) SELECT Statement for Students with More than…

Answered: 1) Write a SELECT statement that…

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter11: Group Functions

Section: Chapter Questions

Problem 18MC

See similar textbooks

Similar questions

Write a SELECT statement that returns two columns basedon the EMPLOYEES table. Contact, is the employeelastname and the first initial of the first name. The secondcolumn, Phone, is the homephone without the area code.Only return rows for those employees in the 206 areacode, sort the results by the last name.
Write a SELECT statement that returns one row for each customer that has orders with these columns: The email_address from the Customers table A count of the number of orders The total amount for each order (Hint: First, subtract the discount amount from the price. Then, multiply by the quantity.) Return only those rows where the customer has more than 1 order. Sort the result set in descending sequence by the sum of the line item amounts. everytime l try to write this sql statement an error occurs
WEEK SQL ASSIGNMENT Complete the following exercise: Alter your student table adding a new column called enroll_date using the datetime data type. Populate the new column (enroll_date) with the current date and time. Using your student table return the student first and last names concatenated with a space and then the enroll_date minus one month. Here is an example of the output: Name Date Jane Smith 2019-05-03 13:14:12 Tom Jones 2020-08-07 05:23:56 Using your student table return the month name for the enroll_date column. For example, if the enroll_date was 11-6-2019 then the month name would be June.
Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code (SALARY, LAST_NAME, STREET, ZIP_CODE) from the EMPLOYEE and ADDRESS tables, sorted by SALARY from largest to smallest. STREET and ZIP_CODE are in the ADDRESS table, while the other fields are in the EMPLOYEE table. The common key is EMPLOYEE_ID.
You have been told that you need to store the zip code for employees. Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause). (you MAY use 1 or 2 statements) Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department
Write a SELECT statement that returns the companyname,address, city and postalcode from the suppliers table wherethe suppliers ID is also in the products table. Order it by thesupplier id in descending order. (returns 29 Rows)
Write a SELECT statement that joins the Instructors and Courses tables and returns these columns: LastName, FirstName, and CourseDescription. Return at least one row for each instructor, even if that instructor isn’t teaching any courses. Sort the result set by LastName and then by FirstName in ascending order.
Write a ASQ statement to return to see all of the first names in the People table. SELECT first name FROM people; WHERE FROM People first name; FROM People SELECT first_name; First name WHERE FROM People;
3. Write a SELECT statement that joins the Departments, Courses, and Instructors tables. This statement should return these columns: DepartmentName, CourseDescription, FirstName, and LastName. Use aliases for the tables and return only those courses with three units. Each course description should only be listed once. Sort the result set by DepartmentName and then by CourseDescription in ascending sequence.
Write a SELECT statement that returns the following columns from the PRODUCT_INFORMATION table. Sort the results by PRODUCT_ID in ascending order. 1. PRODUCT_ID 2. PRODUCT_NAME 3. LIST_PRICE ○ Use the TO_CHAR function to convert LIST_PRICE to a character string with the currency formatting Give this field an alias of PRICE
In SQL When you use ALTER TABLE to add a column, the new column: Select one: a. Will not be created because you cannot add a column after the table is created b. Becomes the last column in the table c. Can be placed by adding a GROUP BY clause d. Becomes the first column in the table
Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns. In addition, you must calculate the order total from the columns in the OrderItems table. Write a second SELECT statement that uses the first SELECT statement in its FROM clause. The main query should return two columns: the customer�s email address and the largest order for that customer. To do this, you can group the result set by the EmailAddress column.

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS