Determine the results of the below query. Explain how the resultwas calculated.72Q.6.473 SELECT Year, SUM(Value)74FROM Import75 WHERE CountryID <> 3GROUP BY Year;76 Table: ImportPrimary key: ImportIDForeign key: CountryIDImportID123DescriptionElectronicsElectronicsMacineryYear201820192018Value15000018000080000CountryID112Write a SQL statement that will change the value of the descriptionfor the Import with ID 3 to "Machinery".

The answer for both the questions are given below along with output screenshot Explanation is also…

Answered: Determine the results of the below…

Determine the results of the below query. Explain how the result was calculated. 72 73 74 75 76 Q.6.4 SELECT Year, SUM(Value) FROM Import WHERE CountryID <> 3 GROUP BY Year;

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: select * from cast where cast_id=162652763; Use explain to display the query plan without creating…

A: the answer is given below

Q: List unique first (first_name) and last names (last_name) of customers (CUSTOMER table) who rented a…

A: In this question, we are asked to write a SQL query to fetch the unique first and last names who…

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: CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the…

A: Answer:- Atrributes: It is a column in a table Table CUSTOMER: Atrributes : 1.custID( Type),…

Q: Based on the reference table, write a query to get list name of employee wl registered more than 10…

A: Please find the Querry below for following question:

Q: 2)Write a query to display the SSN and names of faculty members, and the course number and…

A: Please note that you may need to adjust the table and column names according to your database schema…

Q: 3) Write an SQL query to display the accountno, name, Recurrent_acno, transaction_date whose Fixed…

A: Required:

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: SCHEDULE ID Write a query to delete payment details from payments table where discount coupon 'D1'…

A: According to the Question below the Solution

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

A: To be determine: Which clause can be used to restrict or filter the groups returned by a group…

Q: Insert the following records ito Stadent table Sad Saame Book d 11 Asma 104 12 Ruya 102 13 Mosa 103…

A: As per Bartleby guidelines we need to solve only first 3 questions. Here i have used Mysql workbench…

Q: 1. Write a query to retrieve student id, name, SERA of students from a student into table. 2. List…

A: Note: Here you asked 6 different questions so I'm going to answer the first three questions.…

Q: Write a query that displays the name and hiredate of any employee hired after 24 October 2000 and…

A: Query: Query means a request to retrieve data or information from databases. Query can be either…

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: 1d. Modify the Doctors table by applying the following constraints: Column Name Constraint Salary…

A: Initially, Doctors table is created using the following syntax. CREATE TABLE table_name( column1…

Q: Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The query follows the syntax given below. SELECT column1, column2 FROM table1 WHERE condition ORDER…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

Determine the results of the below query. Explain how the result
was calculated.
72
Q.6.4
73 SELECT Year, SUM(Value)
74
FROM Import
75 WHERE CountryID <> 3
GROUP BY Year;
76

Table: Import
Primary key: ImportID
Foreign key: CountryID
ImportID
1
2
3
Description
Electronics
Electronics
Macinery
Year
2018
2019
2018
Value
150000
180000
80000
CountryID
1
1
2
Write a SQL statement that will change the value of the description
for the Import with ID 3 to "Machinery".

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

Step 1

VIEW

Result of the first question

VIEW

Result and output of last question

VIEW

Step by step

Solved in 3 steps with 3 images

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

A subquery must be placed in the outer query’s HAVING clause if: (refer to the tables in the JustLee Books database.) The inner query needs to reference the value returned to the outer query. The value returned by the inner query is to be compared to grouped data in the outer query. The subquery returns more than one value to the outer query. None of the above. Subqueries can’t be used in the outer query’s HAVING Clause
SQL SUM Problem -SELECT * FROM [Sale Order] INNER JOIN Product ON [Sale Order] productID = Product.productID here i've joined two tables , now what i need to do is sum the productPrice of the rows with the same customerID .. order id and product id are the primary key
Based on the given table. Customer ID Name Balance Payment 193 Chen 2100 300 584 Ravindran 5000 250 231 Bolt 300 20 608 Gomez 950 125 What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM Customer; 3900, 9750, 590, 1775 3600 3600, 9500, 560, 1650
Use multiple-row subquery in a WHERE clause. List order numbers of books, written by an author whose author ID is J100, that were ordered by the customers. Include the following columns in the result. a. Order Numberb. ISBNc. QuantityHint: In this task, we will compare the list of books in the subquery with the list of books in the outer query. The subquery returns ISBN of books that were written by the author J100. The outer query returns all order records (each record contains order number, ISBN, and quantity)
Please help and break down all the steps I should take in order to succesfully complete the query. Create the following query in access: a. The company has been informed that the tax has been increased to 17.5%. Calculatehow much additional tax (i.e., the difference) the store would have collected by year.Name this query Q3 – ADDED-TAX.
Q1 Show all data from employee table where name should be in ascending and salary in descending order? 2 Show the total length of (eno, deptno), joined it and rename by function from the employee table? 3 Show the ename first 3 alphabets of manager? 4 Write a query that show the manager data like this?ename job JONES ***MANAGER BLAKE ***MANAGER 5 Calculate the percentage of any student and round to 0 digit? 6 Show the last date of December 2014? 7 Show the date of next data base class and rename by cs-400? 8 Convert today date to character?
Please write a query for dvdrental database. Please list first names of customers starting with letter L. Include only first names, remove duplicated rows. Please sort rows by first name. postgres
*SQL Query Required* Display schedule_id, source, destination and travel_time which has minimum travel time. Sort the result based on schedule id BUSES P BUS_NO number(11) SCHEDULE BUS NAME Varchar2(20) t varchar2(20) t SCHEDULE_ID TRAVEL DATE varchar2(3) date d varchar2(20) t DESTINATION varchar2(20) t TYPE TOTAL_SEATS number(11) # AVAIL_SEATS number(11) # SOURCE number(11) BU NO number(11) # BUS_NO P BUS NO DURATION PAYMENTS DISCOUNTS P PAYMENT_ID varchar2(3)t varchar2(3) number(11) varchar2(3) TICKET ID BD IDO O TICKET_ID oO BD_ID PDISCOUNT_ID DISCOUNT_AMOUNT number(11) # TICKETS O DISCOUNT_ID varchar2(3) SCOUNT_ID TICKET ID yarchar2(3) HEDULE ID O SCHEDULE ID varchar2(3) number(11) # number(11)O number(11) # FARE USER ID OUSER ID NO SEATS USERS PUSER_ID number(11) varchar2(20) t ADDRESS varchar2(100) t number(11) # EMAILID varchar2(30) t primary key - not null NAME e foreign key PHNO # data type - number d data type - date It| data type - varchar2 CANCELLATION PCANCELLATION_ID…
Write query "Rerange the data in ascendimg order based on the cost of the book"
Write query of it.
use APEX SQL use OEHR_Employees data base from APEX data under utlitlies -->sample datsets Using HR Database (Schema), write a query to return the first_name, last_name and salary for employees who are not working in department #30 (use subquery)
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);