Q5). Write a query that extracts all Table 1. Customers_table the records in the customers table where the customer_id last_name first_name favorite_website 4000 Jackson Joe techonthenet.com Customer's favorite website contains no 5000 Smith Jane digminecraft.com Information. 6000 Ferguson Samantha bigactivities.com 7000 Reynolds Allen checkyourmath.com 8000 Anderson Paige NULL 9000 Johnson Derek techonthenet.com

Q5). Write a query that extracts all Table 1. Customers_table the records in the customers table where the customer_id last_name first_name favorite_website 4000 Jackson Joe techonthenet.com Customer's favorite website contains no 5000 Smith Jane digminecraft.com Information. 6000 Ferguson Samantha bigactivities.com 7000 Reynolds Allen checkyourmath.com 8000 Anderson Paige NULL 9000 Johnson Derek techonthenet.com

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: Create a query for displaying average commission percentage company is giving to its employees.…

A: Format of Query :- SELECT AVG ( coloum name ) AS aliasname FROM tablename; According To question :-…

Q: write a query that displays employee last names, department numbers, and all the employees who work…

A: Here, SELECT statement is used along with the ON, WHERE, and ORDER BY clause.

Q: using the code belowe write a query to display the movie genre and average price rental fee for…

A: In the database analysis, understanding the distribution of movie costs across genres is a crucial…

Q: using the code write a query to display the movie number, movie title, and price code for all movies…

A: Algorithm:Define a table named PRICE with columns PRICE_CODE, PRICE_DESCRIPTION, PRICE_RENTFEE, and…

Q: using the code below write a query to display the movie title, movie year, and movie genre for all…

A: Algorithm: Retrieve and Sort Movie Information by Genre and Year1. Create a MOVIE table with…

Q: using the code write a query to display the movie number, movie title, and movie year for all movies…

A: Algorithm:Create a table named MOVIE with columns for movie information (number, title, year, cost,…

Q: Write query to find the balance characteristics for all customers, including the total of the…

A: Find the balance characteristics of all customers including the total of the outstanding balances.…

Q: Create a query that SELECT all of the EMPLOYEES from the EMPLOYEE TABLE that are Mangers. Include…

A: Self Join: A self join occurs when a table is linked to itself (also known as Unary…

Q: Create a Query with all products information whose price is >20.

A: Lets see the solution.

Q: List every table that contains a column named OWNER_NUM. The output table should display one column…

A: The first ever freely programmable computer came into play in 1936, however after that International…

Q: 3. Write a query that retrieves the following results (note the column names and order of results):

A: The required result needs to fetch below columns : Pub_id -> from publisher table Publisher's…

Q: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

A: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

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: Write a query to display the customer code, first name, last name of all customers who made more…

A: Select: The SELECT statement is used to select data from a database. SELECT Syntax SELECT…

Q: Write a query to display list of students name who all are from IT department. Sort the result based…

A: Given, A relation schema diagram of 5 tables. To write a query to display all student's names from…

Q: Query 2: Write a query to display every member in Ohio who made a payment greater than or equal to…

A: Select (First name, Lastname) from Payment where State = "Ohio" AND Amount>=300; The above…

Q: using the code below write a query to display the movie title, movie genre, price description, and…

A: Select Columns: Choose the columns to be displayed: MOVIE_TITLE, MOVIE_GENRE, PRICE_DESCRIPTION, and…

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: using the code write a query to display the movie number, movie title, movie cost, and movie genre…

A: 1. Create a table named MOVIE: - Define columns: - MOVIE_NUM as INT (Primary Key) -…

Q: Question 4 Write a query to display the first name concatenated with the last name as Full Name, and…

A: This particular question belongs to Computer Science and Engineering. Computer Science is an…

Q: Create a Query with all products information whose price is >20.

A: Lets see the solution.

Q: how is duplicate column prefixed when duplicate column appear in Join Query? a) Table name followed…

A: The question is asking about the way to prefix a duplicate column when it appears in a Join Query in…

Q: LoanID Credit Score Current Loan Info Previous loans Location CitylD Country Province Postal Code…

A: Let's understand the concept of a primary and foreign key. Primary Key:The number one key used…

Q: What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM…

A: The query selects the result of the expression 2*(Balance - Payment) for each row in the "Customer"…

Q: Given the following table TABLE EMPLOYEE Column Null? Туре EMP_ID NOT NULL NUMBER EMP_LNAME…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

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

Q5). Write a query that extracts all
Table 1. Customers_table
the records in the customers table where the
customer_id last_name first_name favorite_website
4000
Jackson
Joe
techonthenet.com
Customer's favorite website contains no
5000
Smith
Jane
digminecraft.com
Information.
6000
Ferguson Samantha bigactivities.com
7000
Reynolds Allen
checkyourmath.com
8000
Anderson Paige
NULL
9000
Johnson
Derek
techonthenet.com

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1 : Explanation

VIEW

Step 2 : Query

VIEW

Trending now

This is a popular solution!

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

Question 2 Write a query to display the last name, job, and salary of all employees whose salaries are less than 10,000 or greater than 15,000 Expect the output of your query to be similar (not necessarily identical) to the following: LNAME JOB SALARY Porter Jalal Sagr Alrashidi Hamdan Kamaleldeen 6 rows selected. CEO HR Officer Accountant PR Programmer Accountant 22000 6500 6880 5000 8750 5750
Create a new table, EMP_PROMOTION to store the employees information. You must use a subquery to create the new table. Make the salary column invisible. Display the structure of the table in SQL Developer. Also use a SELECT statement to display all records from the new table EMP_PROMOTION.
Use the code below to write a query to display the movie title, movie year, and movie genre for all movies CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2011, 39.95, 'FAMILY', 2); INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2008, 59.95, 'ACTION', 1); INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2012, 59.95, 'DRAMA', 2); INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2011, 29.95, 'COMEDY', 2); INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2012, 89.95, 'DRAMA', NULL); INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2002, 25.49, 'DRAMA', 3); INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2009, 45.49, 'ACTION', 1);
Problem 15, Need help please. Use a query to compute the total of all purchases, the number of purchases, and the average purchase amount made by each customer. Your output values must match those shown in Figure P7.15. Sort the results by customer code.
To add new customer to the customer table, the right query is: insert into customer new (4, 'sa 'beirut', lebanon') insert new customer (4, 'sami', 'beirut', lebanon') insert new customer values (4, 'sami', 'beirut', lebanon') insert into customer values (4, 'sami', 'beirut', lehanon')
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear
Write a query to show all record of job-history of those employees whose department number 60? SELECT first_name from employees where first_name like ‘S%’; SELECT first_name from employees where first_name like ‘_e%’; table Name :- EMP EDIT EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7839 KING PRESIDENT - 11/17/1981 5000 - 10 7698 BLAKE MANAGER 7839 05/01/1981 2850 - 30 7782 CLARK MANAGER 7839 06/09/1981 2450 - 10 7566 JONES MANAGER 7839 04/02/1981 2975 - 20 7788 SCOTT ANALYST 7566 12/09/1982 3000 - 20 7902 FORD ANALYST 7566 12/03/1981 3000 - 20 7369 SMITH CLERK 7902 12/17/1980 800 - 20 7499 ALLEN SALESMAN 7698 02/20/1981 1600 300 30 7521 WARD SALESMAN 7698 02/22/1981 1250 500 30 7654 MARTIN SALESMAN 7698 09/28/1981 1250 1400 30 7844 TURNER SALESMAN 7698 09/08/1981 1500 0 30 7876 ADAMS CLERK 7788 01/12/1983 1100 - 20 7900 JAMES CLERK 7698 12/03/1981 950 - 30 7934 MILLER CLERK 7782 01/23/1982 1300 - 10
Write4 query to find the balance characteristics for all customers, including the total of the outstanding balances. The results of this query are shown in Figure P7.39.0.
database HR Write a query to display the last name, job, department number, and department name for all employees who work in Toronto.
Write a Query using JOINS to display the Customer Name, Email, Delivery Address and Final Price of all orders whose Final Price is atleast 200 dollars.
Question #10.Write a query to retrieve invoice_number, invoice_date, and “Balance Due” from the invoices table.Balance Due can be calculated by subtracting payment and credit from the original invoicedamount. Make sure to only select rows with positive “Balance Due” and sort the results basedon Balance Due. Refer to the sample result screen below.
Given a small company database tables below. Create the database and tables for the company and answer all the questions below. LINE CUSTOMER VENDOR INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE Cus CODE CUS_LNAME CUS_FNAME CUS_INITIAL cus AREACODE CUS_PHONE CUS_BALANCE V_CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 1000 3 23100-HB 0.05 10010 Ramas Afred 015 844-2573 21225 Bryson, Ine. Smithson 015 223-3234 TN 1006 4 89-WRE-Q 256.00 10011 Dunne Leona 713 804-1238 21220 SuperLoo, Inc. Flushing 04 215-8006 FL N 1 13-Q2/P2 2 14.00 1007 10012 Smith Kathy 015 804-2205 345.88 21231 DSE Supply Singh 815 228-3246 TN 1007 254778-2T 4.00 10013 Olowski Paul 815 804-2100 530.75 21344 Gomez Bros. Ortega 815 889-2546 KY N 1008 1 PVC23DRT 5.87 10014 Orlando Myron le15 222-1872 22507 Dome Supply Smith 01 e78-1419 GA IN 1008 2 WR3/TT3 3 110.05 10015 OBrian Amy 713 442-3381 23110 Randsets Ltd. Anderson 001 078-3008 GA 1008 3 23100-HB 0.05 10010 Brown James 015 297-1228 221.19 24004…