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: Q2: Do these queries: 1. Show department name and instructor name who is having salary greater than…

A: Due to company policies I am compelled to solve only one question and that is the first question.…

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: Show all name and phone numbers of students and the type of donation they received including any…

A: Show all name and phone numbers of students and the type of donation they received including any…

Q: Use a subquery to find employees' last names and hire date from the employees table whose manager is…

A: Let us see the answer:-

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: What is the index at the end letter of your first name in Yname?

A: Start Input string Yname Input letter you want to find the index Iterate over the string Compare…

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: Query list of all our customers full name and email. Show those whose customer id is either…

A: The above question is solved in step 2:-

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: Display the last name, salary, and commission for all employees who earn commissions. Sort data in…

A: In the above question, needs to find out only those employee's last name, salary, and commission who…

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: Which restaurant id had the highest number of orders placed in June 2021? Write SQL code, The…

A: To determine which restaurant had the highest number of orders placed in June 2021, you can use the…

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: Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN ID DELIVERY_ DATE 1001 300…

A: b) SELECT * FROM PURCHASE_ORDER INNER JOIN PURCHASE_DETAILS ON PURCHASE_ORDER.ORDER_NO =…

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: For each product, show the product ID and the number of orders placed. Show the results in…

A: Introduction: SQL (Structured Query Language) is a database computer language designed primarily for…

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: How do you indicate that a column alias should be used?

A: NOTE: - Below explanation is as per the oracle database. CONCEPT OF COLUMN ALIASING: - The column…

Q: SCHOOL_FEE

A: -- create student tableCREATE TABLE student ( student_id INTEGER PRIMARY KEY, first_name TEXT NOT…

Q: Display details of jobs where the minimum salary is greater than 10000. using sql plus

A: SQL Query: Assume a database JOBS which has Columns JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY. Now,…

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: List the index number, and course number for all classes taught by Dr. Smith during the Fall 02…

A: The query provided is done using SQL and considering all the data is present in a single table as…

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

Select FirstName,LName,start_date from employeetab,Manager where employeetab.manager_id=Manager.managerid group by Department; [please give the explaination of this sql code]
Calculate the "Days on Market" in column L by finding the difference between Date Sold icokumn and Date Listed (column H) first. What is the average Sales Price for all the properties with 2or more bedrooms and more than 180 days on the market?
Under what circumstances must you include a GROUP BY clause in a query?
Mark as unused the Category column in the BOOK_PRICING table. Check that the column is no longer accessible.
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.
Find the compound amount on deposit at the end of 1 year if Php 120, 000 is deposited at 3.5% compounded monthly. Note: Convert your answers in WHOLE NUMBER format only.
Which kind of queuing implies that customers be served in a certain order?
Write a query that returns all customers listed in the orders table who placed orders on the most recently recorded day, return the OrderID, the CustomerID and the OrderDate .
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;