Name of subject: Database ProgrammingDisplay the name of supplier(s) that supplied the most expensive computer?Note: Use Subqueries DROP TABLE computer CASCADE CONSTRAINTS,DROP TABLE location CASCADE CONSTRAINTS;DROP TABLE supplier CASCADE CONSTRAINTS:CREATE TABLE supplier(SuppID NUMBER (3),SName VARCHAR2 (15),SAddress VARCHAR2 120),SPhone VARCHAR2 (12),CONSTRAINT supplier_suppID_PK PRIMARY KEY (suppIDI);CREATE TABLE location(LocID NUMBER (3),Bldg_code CHAR (4),RoonNo NUMNBER (3),CONSTRAINT location locid PK PRIMARY KEY (LOCID) I:CREATE TABLE computer(CompID NUMBER (5),SNumber VARCHAR2 (15),Make VARCHAR2 (20),SuppID NUMBER (3),LocID NUMBER (3),Value NUMBER (6,2),Date purchased DATE,CONSTRAINT computer_compID_PK PRIMARY KEY (CompID),CONSTRAINT computer_suppID_FK FOREIGN KEY (suppID) REFERENCESsupplier,CONSTRAINT computer 10CID FK FOREIGN KEY (10CID) REFERENCES location) :INSERT INTO supplier VALUES (122, 'Compag Sdn. Bhd', '10 Jalan Duta','03-989898');INSERT INTO supplier VALUES (123, 'ASUS Sdn. Bhd', '12 Jalan Duta','03-2323231;INSERT INTO supplier VALUES (124, 'IBM Sdn.Bhd', '15 Jalan Duta', '03-565656'):INSERT INTO supplier VALUES (125, 'Apple Sdn.Bhd', '18 Jalan Duta','03-785676')INSERT INTO location VALUES (222, 'LAN', 343):INSERT INTO location VALUES (333, 'IRK', 343)INSERT INTO location VALUES (444, 'ICT', 343)INSERT INTO computer VALUES (13321, "XDX12345', "Compaq', 122, 222,2300.50, 70 DATE ('12-JAN-2008', 'DD-MON-YYYY')):INSERT INTO computer VALUES (13322, 'XDX12344', 'ASUS PC', 123, 222,3000.80, TO DATE ('17-JAN-2008', 'DD-MON-YYYY')):INSERT INTO Computer VALUES (13323, "XDX12343', 'IBM', 124, 333,2800.50, TO_DATE ('12-DEC-2008', 'DD-MON-YYYY'));INSERT INTO computer VALUES (13324, "XDX12342', 'Apple', 125, 444,5300.50, TO_DATE ('12-JUN-2009', 'DD-MON-YYYY')) :INSERT INTO computer VALUES (13325, "XDX12341', 'Apple', 125, 444,6300.50, T0 DATE ('12-JUN-2009', 'DD-MON-YYYY')):INSERT INTO computer VALUES (13326, "XDX12346', 'Apple', 125, 444,6000.85, 70 DATE ('12-JUN-2009', 'DD-MON-YYYY')):COMMITI

we can't directly use aggregate functions in where clause. writing select columnName from tableName…

Answered: Display the name of supplier(s) that…

Engineering

Computer Science

Display the name of supplier(s) that supplied the most expensive computer?

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: The Book table has the following columns: ID Title Author Genre Year Price Complete the SELECT…

A: To complete the `SELECT` statement to select the year and the average price of books for that year,…

Q: Show students’ first name, last name, the grades of the students, and the credits of the course for…

A: Select St.FristName, St.LastName, Et.Grade, C.CourseIDfrom Student St INNER JOIN Enrollment Et ON…

Q: if you want to get username from user table how to do this query O SELECT USERNAME FROM USER GET…

A: The USER_NAME() function returns the database user name based on the specified id. If id is not…

Q: t the title of all books in the same category as books previously purchased by customer 1007. Don’t…

A: Lets see the solution.

Q: The Book table has the following columns: ID Title Author Genre Year Price Complete the SELECT…

A: The question is asking for a SQL query that will return each genre and the total number of books in…

Q: True or False Each column in a table must have a name.

A: Each column in a table must have a unique name. The entries within each column should match with…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: We need to write a SQL query that prints the table that has columns are- FirstName, LastName,…

Q: Find the service ID and property ID for each service request whose estimated hours is greater than…

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: ? List each order number and the date it shipped. SQL comm

A: Solution - In the given question, we have to write the SQL command for the given query.

Q: Explain when you would prefer to use embedded SQL over SQL or a general-purpose programming…

A: Embedded SQL is a technique that allows SQL statements to be integrated directly into a…

Q: plz help with the following use oracle sql or sql live The procedure should satisfy the following…

A: Answer is given below .

Q: NOTE; language SQL List the office number, address, and monthly rent for properties whose owners…

A: Database: A database is used to store a huge amount of data records. Generally, most industries or…

Q: The following SQL clause(s) are not permitted to be used in a subquery in the WHERE or HAVING…

A: Multicolumn subqueries cannot use the <, >, <=, >= comparison operators.

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition. student…

Q: In SQL, what statement do you use to retrieve specific rows from a table in a database?

A: SELECT: The "SELECT" statement is been used for selecting rows from a database. All the fields…

Q: Write the following as MySQL query: Find the department name whose location (Country_ID) is DE. Use…

A: SQL, which stands for Structured Query Language, is a domain-specific programming language used for…

Q: 2. Determine which orders haven’t yet shipped and the name of the customer who placed the order.…

A: According to the information given:- We have to follow the instruction in order to perform the…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: Queries can be used within statement(s): update delete All of the answers Insert

A: A SQL is a Structured Query Language. It uses queries to create database and extract information…

Q: How does the PARSE function differ from the TRY_PARSE function in SQL when converting data types?

A: Effective database administration in the world of SQL programming depends on the capacity to alter…

Concept explainers

Basic SQL Queries

Structured Query Language is the full form of SQL. It is a high-level language used to communicate with a relational database. It is used for creating, storing and accessing contents of a relational database. SQL is used to write the queries which are executed using database engines like Oracle, SQL Server and so forth.

Question

100%

Name of subject: Database Programming

Display the name of supplier(s) that supplied the most expensive computer?

Note: Use Subqueries

DROP TABLE computer CASCADE CONSTRAINTS,
DROP TABLE location CASCADE CONSTRAINTS;
DROP TABLE supplier CASCADE CONSTRAINTS:
CREATE TABLE supplier
(SuppID NUMBER (3),
SName VARCHAR2 (15),
SAddress VARCHAR2 120),
SPhone VARCHAR2 (12),
CONSTRAINT supplier_suppID_PK PRIMARY KEY (suppIDI);
CREATE TABLE location
(LocID NUMBER (3),
Bldg_code CHAR (4),
RoonNo NUMNBER (3),
CONSTRAINT location locid PK PRIMARY KEY (LOCID) I:
CREATE TABLE computer
(CompID NUMBER (5),
SNumber VARCHAR2 (15),
Make VARCHAR2 (20),
SuppID NUMBER (3),
LocID NUMBER (3),
Value NUMBER (6,2),
Date purchased DATE,
CONSTRAINT computer_compID_PK PRIMARY KEY (CompID),
CONSTRAINT computer_suppID_FK FOREIGN KEY (suppID) REFERENCES
supplier,
CONSTRAINT computer 10CID FK FOREIGN KEY (10CID) REFERENCES location) :
INSERT INTO supplier VALUES (122, 'Compag Sdn. Bhd', '10 Jalan Duta',
'03-989898');
INSERT INTO supplier VALUES (123, 'ASUS Sdn. Bhd', '12 Jalan Duta',
'03-2323231;
INSERT INTO supplier VALUES (124, 'IBM Sdn.Bhd', '15 Jalan Duta', '03-
565656'):
INSERT INTO supplier VALUES (125, 'Apple Sdn.Bhd', '18 Jalan Duta',
'03-785676')
INSERT INTO location VALUES (222, 'LAN', 343):
INSERT INTO location VALUES (333, 'IRK', 343)
INSERT INTO location VALUES (444, 'ICT', 343)
INSERT INTO computer VALUES (13321, "XDX12345', "Compaq', 122, 222,
2300.50, 70 DATE ('12-JAN-2008', 'DD-MON-YYYY')):
INSERT INTO computer VALUES (13322, 'XDX12344', 'ASUS PC', 123, 222,
3000.80, TO DATE ('17-JAN-2008', 'DD-MON-YYYY')):
INSERT INTO Computer VALUES (13323, "XDX12343', 'IBM', 124, 333,
2800.50, TO_DATE ('12-DEC-2008', 'DD-MON-YYYY'));
INSERT INTO computer VALUES (13324, "XDX12342', 'Apple', 125, 444,
5300.50, TO_DATE ('12-JUN-2009', 'DD-MON-YYYY')) :
INSERT INTO computer VALUES (13325, "XDX12341', 'Apple', 125, 444,
6300.50, T0 DATE ('12-JUN-2009', 'DD-MON-YYYY')):
INSERT INTO computer VALUES (13326, "XDX12346', 'Apple', 125, 444,
6000.85, 70 DATE ('12-JUN-2009', 'DD-MON-YYYY')):
COMMITI

Organized collection of structured information, or data, typically stored in a computer system.

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

Step 2

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

C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
5. Display the current day of the week, hour, minutes, and seconds of the current date settingon the computer you’re using. SQL commands
Query: List the IDs of the tutors who are currently tutoring more than one student
Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors' telephone number and address On this day in the suburbs of the city
The following fields are presented in the table: Member Last Name, MemberFirstName, Street, City, State, ZipCode and MemberFee. The table contains 75,000 documents. How would you build indexes for the table and why would you create these indexes?
List the employee’s first and last name and the department name he/she does NOT belong topurchasing, shipping, or sales departments. Use Not operator.
List the names of all customers that have a credit limit of $7,500 or less
SQL Write a query that displays the VendorID, Vendor Name and Total Invoice for each Vendor in California. Please note that you must use multiple tables
IN SQL If you omitted the WHERE clause of SELECT statement, the query returns an error because the where clause is required. Select one: True False
SQL Find the guide last name and guide first name of all guides who can lead a paddling trip
SQL Database Designs What do you think is the most important concept in SQL Database Designs
Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)