Create the following table in your database with the following schema: Table: Customer +- | Column Name | Type +. | id | int | varchar | | int | name | referee id +- ---+ id is the primary key column for this table. Each row of this table indicates the id of a customer, their name, and the id of the customer who referred them. Add the following data to your tables: Input: Customer table: +----+----- | id | name | referee id | +----+------ | 1 | 2 | 3 | 4 | 5 | 6 | will | null | Jane | null | Alex | 2 | Bill | null | Zack | 1 | Mark | 2 +--- Write an SQL query to report the IDs of the customer that are not referred by the customer with id 2.

Create the following table in your database with the following schema: Table: Customer +- | Column Name | Type +. | id | int | varchar | | int | name | referee id +- ---+ id is the primary key column for this table. Each row of this table indicates the id of a customer, their name, and the id of the customer who referred them. Add the following data to your tables: Input: Customer table: +----+----- | id | name | referee id | +----+------ | 1 | 2 | 3 | 4 | 5 | 6 | will | null | Jane | null | Alex | 2 | Bill | null | Zack | 1 | Mark | 2 +--- Write an SQL query to report the IDs of the customer that are not referred by the customer with id 2.

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: PLZ help with the following use oracle or oracle sql live problem is in image the database CREATE…

A: The complete answer is given below.

Q: question 9 please use the picture below to answer the following question Write a SQL statement to…

A: Query: The below query is used to create a table named “new_Invoice” which is exactly the same as…

Q: assume that a database has a table named Stock, with thefollowing columns:Column Name…

A: Select statement is used for selecting data from the database. Syntax: SELECT column1, column2,…

Q: Create a query that will show the person id and fee for all players in the football database.…

A: SQL, or Structured Query Language, which refers to the one it is a programming language used to…

Q: database with Howing BUIMOTTO Table: Employees | Column Name 1 Туре I id | int | varchar I I name…

A: The SQL queried is given below.

Q: The Car Maintenance team wants to update the price of Oil Change to 75. In addition, they will no…

A: We need to write the MYSQL query to update the price of Oil Change to 75 and remove the maintenance…

Q: The Driver Relationship team wants to have quick search options for the active drivers. The team…

A: Task 4: INDEX is used search/retrieve data more quickly. It is basically used to speed up query.…

Q: how to create a metadeta fore this SQL script: -- creating the clinic DataBase CREATE DATABASE…

A: Answer is given below.

Q: # Question 1 #Using the World database, in the city table, insert a new city for the Tasmania…

A: What is SQL: SQL is a language for interacting with databases. SQL is the standard language for…

Q: Create the following table in your database with the following schema: Table: Orders | Column Name |…

A: Firstly we will create the table by using below command: CREATE TABLE Orders ( order_number…

Q: Create the following table in your database with the following schema: Table: orders | Column Name 1…

A: Here are all the queries:

Q: Prodcts The Nectbuodoattadera database contains sales data for a fictitious company called Northwind…

A: In screen short :- Database management system table is present in this screen short where one table…

Q: MySql Workbench CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name…

A: As per Bartleby's rules, we can answer the first 3 subparts of a question I have answered Q 1, 2 3…

Q: (a) Write a complete PL/SQL Cursor to retrieve the following information. Fetch row number, Employee…

A: Question (a) DECLARERow_Number Numeric(10);E_ID employees.employee_id%type;E_FName…

Q: Consider the following table in a relational database. Last Name Rank Room Shift Smith Manager 234…

A: A candidate key is an attribute or set of attribute which can identify all tuple uniquely.

Q: rite the syntax to insert into a relational table called students the address column references an…

A: Lets see the solution.

Q: Assume that a database has a table named Stock, with the following columns:Column Name…

A: SELECT: The "SELECT" statement is been used for selecting data from a database. The result table is…

Question

Create the following table in your database with the following schema:
Table: Customer
| Column Name
Туре
| id
| int
| name
varchar |
| int
| referee id
id is the primary key column for this table.
Each row of this table indicates the id of a customer, their name, and the id
of the customer who referred them.
Add the following data to your tables:
Input:
Customer table:
+--
| id | name | referee id |
| 1
| 2
| 3
| 4
| 5
| 6
| will | null
| Jane | null
| Alex | 2
| Bill | null
| Zack | 1
| Mark | 2
+---
Write an SQL query to report the IDs of the customer that are not referred by the customer with id =
2.
Return the result table in any order.
The results should be:
Output:
| name |
| will |
| Jane |
| Bill |
| Zack |

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

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 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

You've been asked to create a database for a local zoo. The database consists of the following tables: Animals This table contains the following data about all animals in the zoo. animal ID animal name animal birthdate species habitat Habitats This table contains data about the habitats in the zoo. Each animal lives in a specific habitat. The habitat table should include the following data habitat name habitat location Exercises Complete the following exercises to create an executable SQL script which is the physical design for this database. You should be able to execute this script to create and populate the database with test data. Write a query to create the zoo database. Write queries to create the tables. Be sure to include primary keys for each table and the required foreign keys and referential ntegrity actions. Add approriate indexes. This database requires at least 2 indexes in addition to those automatically created by MySQL. Add at least 5 rows to each table.
q4- Choose all that apply
SQL Help The Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information: Car ID Month Day Count You need to create a summary table using the WITH ROLLUP modifier and grouped by the specific column names, listed above, and send the data back to the team. Query the frequency of each car's use by month and day
SQL FOR THERES TABLES
Write a select statement for the following: Join all the tables of the lunches database together (Anything table starting with L_). Show all the columns of each table. To do this, modify the select statement in this section and add the three other tables to it. How many rows and columns are in this table?
Use your ERD to define the table structures in the database using SQL DDL commands to build your schema.
Topic: Database Software: SQLite Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL, birthYear YEAR(4) NULL, deathYear YEAR(4) NULL, age INT NULL, movieNum INT NULL, PRIMARY KEY (nconst)); CREATE TABLE title_episode (episodeID VARCHAR(45) NOT NULL,parentTconst VARCHAR(45) NULL, seasonNumber INT NULL,episodeNumber INT NULL, PRIMARY KEY (episodeID), CONSTRAINT parentTconst FOREIGN KEY (parentTconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_principals (tconst VARCHAR(45) NOT NULL, ordering INT NULL, nconst VARCHAR(45) NULL, category VARCHAR(45) NULL,job VARCHAR(45) NULL, characters VARCHAR(45) NOT NULL, PRIMARY KEY (tconst, characters), CONSTRAINT nconst FOREIGN KEY (nconst)REFERENCES name_basics (nconst) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT tconst FOREIGN KEY (tconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_ratings…
question 5 please use the picture below to answer the following question Assuming all other tables are already created, write a SQL statement to create the following tables and the given constraint(s).
Given the following schema, answer the following questions USERS Attribute Data Type USER_ID NUMBER(3) USER_NAME VARCHAR2(20) USER_TYPE VARCHAR2(10) USER_LIMIT NUMBER(1) BOOKS Attribute Data Type BOOK_ID NUMBER(5) BOOK_TITLE VARCHAR2(25) BOOK_YEAR VARCHAR2(4) Write the SQL code that will create the tables structures for the tables named Books, and Users. Identify and include any PK and FK for both tables.