Consider the following structure of an 'inventory' Oracle database.ALEMADMMERIO ($)WCHAR30)VARCHAR (15DECMALOTOMER D MERC(S)MAMECUST J ROWR(CITYCOMMISSIONcTYRCHAR(SORADEMMERIC(3)SALESMAD UMERC($)ordersORD NOPURCH AMTNUMERIC ($)DECIMAL (82)ORD DATEDATECUSTOMER ID NUMERIC (5)SALESMAN ID NUMERIC (5)List all customers who are either from New York or had a grade above 100.Use the editor to format your answer81

SELECT CUST_NAME FROM CUSTOMER WHERE CITY='NEW YORK' OR GRADE>100;

Answered: List all customers who are either from…

Engineering

Computer Science

List all customers who are either from New York or had a grade above 100.

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: LIST THE FIRST AND LAST NAMES OF ALL OWNERS WHO OWN A TWO-BEDROOM PROPERTY. USE THE IN OPERATOR IN…

A: Considering there are 2 tables:- OWNER: which holds the OWNER_NUM, FIRST_NAME, and LAST_NAME…

Q: List all book titles that have never been borrowed by any borrower.

A: The SQL program for the given problem is as follows: use demo;Create table Book(ISBN varchar(30) Not…

Q: List every column in the Condo_UNIT table and its associated typ

A: The, database is a used to stores the data.

Q: mysql> select * from item_db; | item_code | item_name 2 B 8 10 33 85 200 500 9 6 rows in set (0.00…

A: The number of orders made for the item with code '200' directly from the provided item_db table.…

Q: List the order number and order date for every order that was placed by Mary Nelson and that…

A: SQL, or Structured Query Language, is a programming language designed for managing and manipulating…

Q: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

Q: Check the current stock to see what categories of books are available. Once per category only…

A: Because of this, we make use of the DISTINCT clause so that we may get rid of data set by getting…

Q: 1. Which customers live in New Jersey? List each customer’s last name, first name, and state.

A: The solution is given in next step: Let's say that the table's name is Customer for the moment.

Q: 4. Which customers live in Georgia or New Jersey? Put the results in ascending order by last name.…

A: Assume that, the name of the table is Customer The entities of Customer table are last name, first…

Q: Display the PID and average prices from the PRODUCTS table which price is less than the average…

A: Here we need to perform group by operation in the main query and use Having clause to select only…

Q: Write query "List the title and ISBN of all books using the BOOKS table"

A: Query to display all the records of the books table: SELECT ISBN, BOOK_TITLE FROM BOOKS;

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: Result : Honda Toyota 2 3 O Select Make, Count(Make) FROM Auto Group By Make; Select Make,…

A: COUNT() is an aggregate function that counts the number of rows returned by a query.The HAVING…

Q: List the trip name, trip id and customer number of all reservations for hiking trips. Sort the…

A: Explanation: The query displays the trip id, trip name, and start location using the “TRIP” object…

Q: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

A: For each order id, calculate the total of the Order. The total of an order is the sum of the prices…

Q: Mark as unused the Category column in the BOOK_PRICING table. Check that the column is no longer…

A: The BOOK_PRICING table is a part of a database used for managing pricing information for books. One…

Q: Display Customer name (concatenate First Name and Last Name with a space between) and total number…

A: In order to concatenate the 'FNAME' with 'LNAME' use the '+' sign to combine them. Use the SELECT…

Q: customer who orders the b

A: SUMMARYTo perform this hobby, confer with the tables within the JustLee Books database. The…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Which group function can be used to perform a count that includes NULL values?

A: Group by functions are : SUM ( [ALL | DISTINCT ] expression ) AVG ( ALL | DISTINCT ] expression )…

Q: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit…

A: Here, the new record has to be added to a table and this process is called as Insertion and the…

Q: List the names of all Staff members who hold a faculty position and have a salary of $45,000 or…

A: SQL Space: To leave the space while displaying the data ,a function called space is used. Syntax:…

Q: In the BOOK_PRICING table, you should indicate that the Category field is not being utilized.…

A: The BOOK_PRICING table is a portion of a database used for storing price information for books. One…

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

Consider the following structure of an 'inventory' Oracle database.
ALEMAD
MMERIO ($)
WCHAR30)
VARCHAR (15
DECMAL
OTOMER D MERC(S)
MAME
CUST J ROWR(
CITY
COMMISSION
cTY
RCHAR(S
ORADE
MMERIC(3)
SALESMAD UMERC($)
orders
ORD NO
PURCH AMT
NUMERIC ($)
DECIMAL (82)
ORD DATE
DATE
CUSTOMER ID NUMERIC (5)
SALESMAN ID NUMERIC (5)
List all customers who are either from New York or had a grade above 100.
Use the editor to format your answer
81

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 with 1 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

1. List the book title and retail price for all books with a retail price lower than the averageretail price of all books sold by JustLee Books.
can you slove more 3 queries
5. Which orders were placed on or before April 1, 2009? List each order number and orderdate. Write this query in two different ways.
7. List the shipping city and state for the order that had the longest shipping delay. SQL commands
Which one of the following SQL select statements will display a list of all vendors that do not yet have names entered in the vendor table? Question 8 options: 1) select vend_code, vend_name from vendor where vend_name IS NULL; 2) select vend_code, vend_name from vendor where vend_name IS NOT NULL; 3) select vend_code, vend_name from vendor where vend_name = NULL; 4) select vend_code, vend_name from vendor where vend_name = NOT NULL;