SQL statement needed List the names (first and last) of all the individuals who do not...

Question

Question

SQL statement needed List the names (first and last) of all the individuals who do not...

SQL statement needed

List the names (first and last) of all the individuals who do not report to any other person. (Note: Full credit will NOT be given for the use of IS NULL)

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

where is the schema diagram. or tables description?

Even you have not provided the column names.

Waiting for reply.

Add a comment

Answer 2

Similar Homework Help Questions

Given the following table structure, write the SQL code to display all the first and last...

Given the following table structure, write the SQL code to display all the first and last names of the individuals that have a last name that begins with the letter 'M! CREATE TABLE Persons Personi int LastName varchar(80). FirstName varchar(80). Address varchar(125). State char(2) Given the following table structure, write the SQL code to display all the first and last names of the individuals that have a last name that does not contain the letter 'S: CREATE TABLE Persons PersonlDint,...
(IN SQL) /* 6. Create a list of all the products (prod_id and name) if all...

(IN SQL) /* 6. Create a list of all the products (prod_id and name) if all the following are true (7 records) Supplierid = 2, 5, 16, 8, or 9 Categoryid = 1, 2, or 4 Unitprice > 15.00 */ /* 7. Create a list of all the products (prod_id and name) if all the following are true (11 records) Supplierid = 2, 5, 16, 8, or 9 AND Categoryid...
NEED the SQL query that solves each problem 4) List the member numbers of all members...

NEED the SQL query that solves each problem 4) List the member numbers of all members who rented a movie. Do not list duplicates. (w3schools -> SQL Distinct) 5) List the member names [first and last] for members from Kentucky {KY}. (w3schools -> SQL Where) 6) List the names of all movies in alphabetical order (w3schools -> SQL ORDER BY) 7) List the movie title and cost in descending order by cost (w3schools -> SQL Order By) 8) List all...

1. Write a query to list the first name and last name of those pilots who...

1. Write a query to list the first name and last name of those pilots who were hired after January 1, 2010. Sort your result by the ascending order of last name. Within matching last names, order by first name. 2. Write a query to list flight number, pilot number, pilot last name for all flights whose destinations are using the IN keyword. 3. Write a query to list the names and telephone numbers of the passengers who have reservations...
Instructions All documents and SQL code must be zipped into a single file and uploaded to...

Instructions All documents and SQL code must be zipped into a single file and uploaded to Blackboard All SQL code must run error-free for full credit. The SQL file will be uploaded by the instructor into SQLPlus to check for syntax – so ensure that your file does not contain any syntax errors. All SQL code must be commented appropriately The Prince William County Humane Center wants a database for storing information on their pets. Create the table(s) needed to...
2) What were the total rental fees for each member by member last name? (w3schools-> SQL...

2) What were the total rental fees for each member by member last name? (w3schools-> SQL Inner Join& SQL Functions Count, Avg, Sum & SOL Group By)- this requires 2 joins 13) What were the total rental fees for members treport Mem num who total fees were greater than $5-change the output label to FeesMoreThan5S? (w3schools->SQL Inner Join & SQL Functions Count, Avg, Sum& SQL Group By & SQL Having) 14) What was the highest fee paid by each member...

Write the sql statement that returns a list of store's cities and countries. Where are they...

Write the sql statement that returns a list of store's cities and countries. Where are they located (city and country)? Show your results. Write the sql statement that returns the total revenue for those stores. Show your results including store number, city and country. Write the sql statement that returns the total revenue per year for those stores. Show your results including store number, city and country. Write the sql statement that returns the average revenue per month regardless of...
SQL Command - Create a view called S LIST that lists the Cardholder Number, last name,...

SQL Command - Create a view called S LIST that lists the Cardholder Number, last name, first name and due date for all cardholders who have not returned a book. Use the CREATE OR REPLACE VIEW AS ... command. TABLE CARD HOLDERS Cardholder Numberint NOT NULL CONSTRAINT CH PK PRIMARY KEY, First_Name varchar(10) NULL, LastName varchar(15) NULL, Address varchar(20) NULL, varchar(15) NULL, State char(2) NULL, Zip_Code char(5) NULL) City TABLE BOOKS CHECKED OUT Cardholder_Numberint NOT NULL, Book Numberint NOT NULL,...
1) Write SQL to return the first and last name of all actors with a first...

1) Write SQL to return the first and last name of all actors with a first name of "ADAM" (use the ACTOR table) 2) Write SQL with the LIKE operator to return addresses that are in the "Dhaka" district and have street addresses that do not contain the character sequence "Loop". You can return all information from the ADDRESS table that matches this criteria. 3) Write SQL with the BETWEEN and ORDER BY clause to return the payments in descending...

Use only a single SQL statement for each of the following questions 1 Give a listing of all the ssns,first names and the class descriptions of all the classes the students are taking. If there a...

Use only a single SQL statement for each of the following questions 1 Give a listing of all the ssns,first names and the class descriptions of all the classes the students are taking. If there are no class _descriptions display 'No description is available yet'. (USE NVL) 2 Give a listing of only the lname and the class_code for students who are taking 'Introduction to C programming'. (Inner join) 3 Give a lising of all the class_descriptions and the number...

SQL statement needed List the names (first and last) of all the individuals who do not...

Homework Answers

Add Answer to:
SQL statement needed List the names (first and last) of all the individuals who do not...

Post as a guest

Earn Coins

Given the following table structure, write the SQL code to display all the first and last...

(IN SQL) /* 6. Create a list of all the products (prod_id and name) if all...

NEED the SQL query that solves each problem 4) List the member numbers of all members...

1. Write a query to list the first name and last name of those pilots who...

Instructions All documents and SQL code must be zipped into a single file and uploaded to...

2) What were the total rental fees for each member by member last name? (w3schools-> SQL...

Write the sql statement that returns a list of store's cities and countries. Where are they...

SQL Command - Create a view called S LIST that lists the Cardholder Number, last name,...

1) Write SQL to return the first and last name of all actors with a first...

Use only a single SQL statement for each of the following questions 1 Give a listing of all the ssns,first names and the class descriptions of all the classes the students are taking. If there a...

SQL statement needed List the names (first and last) of all the individuals who do not...

Homework Answers

Add Answer to: SQL statement needed List the names (first and last) of all the individuals who do not...

Post as a guest

Earn Coins

Add Answer to:
SQL statement needed List the names (first and last) of all the individuals who do not...