run the SQL queries to return only the requested data. You must write only one SQL statement per item. That means only one semicolon ( ; ) in your answer. You may have subqueries in your statement. List the movie id, title, production id, and production name for all movies, sorted by the id of the movie, in decreasing order (largest first).

run the SQL queries to return only the requested data. You must write only one SQL statement per item. That means only one semicolon ( ; ) in your answer. You may have subqueries in your statement. List the movie id, title, production id, and production name for all movies, sorted by the id of the movie, in decreasing order (largest first).

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter8: Sql Functions And Procedures

Section: Chapter Questions

Problem 7SCG

See similar textbooks

Similar questions

Instructions Write SQL queries to solve the following problems. We will be using the “university” database. All queries should involve only the instructor table. After you are done, save your work as .sql file and turn in the .sql file into Moodle for grading. Write a SQL statement to display all columns using the SQL asterisk (*) wild-card character. Write a SQL statement to display ID and name of the instructors (ID appears first). Write a SQL statement to display department names. Write a SQL statement to display unique department names. (expect 7 rows returned) Write a SQL statement to display all info about instructors having a salary greater than 75000. (expect 6 rows returned) Write a SQL statement to display department name, instructor name, and salary for instructors that have a salary less than 70000. Sort the results in ascending order by department name. (expect 4 rows returned) Write a SQL statement to display name, department name, and salary for instructors that have a…
Use FOR loop for your cursor. Write a PL/SQL block to read and display the department name and number of employees per department. Accept input from the user to get the number of employees he wants to see in the output. Display also the number of records returned by your PL/SQL block.
run the SQL queries to return only the requested data. You must write only one SQL statement per item. That means only one semicolon ( ; ) in your answer. You may have subqueries in your statement. List the movie title and its production company name for all movies.
Write the SQL code that will produce the same information that was shown in Problem 2, but sorted by the employee’s last name. The results of running that query are shown in Figure P7.3.
Get all students id and name whose marks are greater than average mark in SQL in section
Write SQL code for (see image for the table structure): Create a stored procedure “changeCreditLimit” to change the credit limit for a given customer. If the customer’s total payment amount (note: payment amount is in the table “payments”) is not smaller than a given amount, then add 2000 to the customer’s credit limit (note: credit limit is in the table “customers”).
Using the Online SQL Editor, answer the following questions with screenshots. Link: https://www.programiz.com/sql/online-compiler/ 1. Provide the list of complete names (first & last name) and country of customers whose age is recurring in the list more than once; select and show the count column as Age and rename such column as “22_Years_Old”. Answer(screenshot of code & output from SQL Editor). 2. Show all the columns of the particular item from the order table with the highest price (amount) from the list. Answer(screenshot of code & output from SQL Editor). 3. (1) Show items and amounts from the order table; compute the average amount; rename the column as “Average_price”; then group the columns by item. (2) Compute the sum of all amounts pertaining to keyboard from the order table; rename the column as “Total_price_keyboard”. Answer(screenshot of code & output from SQL Editor).
Question 11 Write SQL statements to answer the following question based on the ERD below. Note: Display only the attribute(s) required in the question. You need to provide complete answers, writing just keywords like SELECT, FROM, WHERE will receive 0 point. Question: List course name, section ID, and the average student grade (as GPA) in that section, for each section that was offered in 'Spring 2010' and order the result in descending order of section ID. STUDENT PK G_number FirstName LastName Address REGISTRATION PK FK G_number PK FK Sectionid DateEnrolled Grade 140 (DC) ALT+N+F10 (Mac) COURSE PK CourseID PK CourseName Course Desc CourseDept F SECTION SectionID FK Course D Semester Year Է t + 78v ABC > 5 600
By using this table answer this question in SQL : Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number and department name should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.
Based on the table provided, write the following statements in sql queries.
From the Salesman and Customer tables below, write SQL statements to do the following: List the salesman id, rating and names of those salesmen who get rating from 3 to 5, sorted DESCENDING by rating. List all the customers’ information whose name starts with ‘F’ and the fourth character is ‘I’, rests may be any character. List the name and country of those customers and salesmen who belongs to the same country. Salesman table: Customer table:
Using the Online SQL Editor, answer the following questions with screenshots. Link: https://www.programiz.com/sql/online-compiler/ 1) Show the columns item and amount from Orders table which starts with the letter “M” but doesn’t end with the letter “r”; 2) Show the first name and last name columns from the Customers table which either starts with the letter “J” or ends with the letter “e”. Answer(screenshot of code & output from SQL Editor)