In sql: Write a query to produce a listing of unique vendor names who have at...

In sql: Write a query to produce a listing of unique vendor names who have at least one invoice with us. You are using a table view called COMPANY_INFORMATION that lists a vendor id, vendor name, term id, and term description. The second table you will reference is the invoice table that lists vendor id, invoice num, invoice number, and invoice total. Do not show duplicate results.

Expert Solution

Use Following query to produce a listing of unique vendor names who have at least one invoice with us.

SELECT DISTINCT vendorName FROM COMPANY_INFORMATION ci JOIN Invoice i ON ci.vendorId = i.vendorId;

We can join table using vendorId and for unique names use DISTINCT keyword.

venereology answered 4 months ago

1. Write a query in SQL to find the full name of the “Actors” who appeared...

1. Write a query in SQL to find the full name of the “Actors” who appeared in the movie titled Star Wars (using JOIN ). 2.Write a SQL query to find the movie Title that has received Lowest rating from reviewers, but whose actors have received an award for their contribution in movie. (Expected Output: Fantastic Beasts and Where to Find Them) 3.Write a SQL query that display the list of genres, Number of movies in that genre grouped by...

1.Write an SQL query that retrieves all pairs of suppliers who supply the same product, along...

1.Write an SQL query that retrieves all pairs of suppliers who supply the same product, along with their product purchase price if applicable. 2.Create a view SUPPLIEROVERVIEW that retrieves, for each supplier, the supplier number, the supplier name, and the total amount of quantities ordered. Once created, query this view to retrieve suppliers for whom the total ordered quantity exceeds 30. 3.Write a nested SQL query to retrieve all purchase order numbers of purchase orders that contain either sparkling or...

How to write a query in SQL using the Group by function to decide if the...

How to write a query in SQL using the Group by function to decide if the results of the diet worked. There are 6 columns ID, Gender, treatment, start_weight_kg, end_weight_kg, and correct change (end weight minus start weight). With the information given write a SQL to determine if the the results(correct change) worked. Question is not incomplete.

HOW TO: 1. Write the SQL statement to show workers with names that have the letter...

HOW TO: 1. Write the SQL statement to show workers with names that have the letter ? before the last character. 2. Write the SQL statement to show all staff where the 2nd letter of their last names is ′?′ 3. Write the SQL statement to show all staff where the 1stletter of their first names is ′?′ and 3rd letter ′ℎ' DROP TABLE IF EXISTS staff; CREATE TABLE staff ( staffNo VARCHAR(4) UNIQUE, fName VARCHAR(16), lName VARCHAR(16), position VARCHAR(16),...

Write the names of 12 people who have, in some way, shaped who it is that...

Write the names of 12 people who have, in some way, shaped who it is that you have become. These might be from your past or your present, real or fictional, someone whom you may or may not have actually met, someone who affected you in a positive or a negative way, etc. After each name, write a sentence or two about the way(s) in which the person influenced your identity. Example: 1. Mother—She instilled a sense of responsibility in...

5. Write the SQL query that accomplishes the task in the ZAGI Retail Company Sales Department...

5. Write the SQL query that accomplishes the task in the ZAGI Retail Company Sales Department Database: 5.1.3. Display the CustomerName and CustomerZip for all customers, sort alphabetically by CustomerName. 5.1.4. Display the RegionID of regions where we have stores (use only table STORES and do not display the same information more than once). 5.1.5 Display all the information for all stores whose ReigionID value is C 5.1.8 Display the ProductID, ProductName, ProductPrice, and VendorName for all products. Sort the...

Write an SQL query that will output the employee id, first name and hire date from...

Write an SQL query that will output the employee id, first name and hire date from the employee table. Pick only those employees whose employee ID is specified in the employee table (no nulls). If the employee id is 777, name is ABC and hire date is 01-JAN-2016, the output should be like - ' ABC (Employee ID - 777) was hired on 1, January of 2016'. Note - The date should not have preceding zeros.

Write a SQL query that displays the number of customers from Mexico, USA, and Canada. Hint:...

Write a SQL query that displays the number of customers from Mexico, USA, and Canada. Hint: The result of the SQL query should look like the following table: CustomerCountNorthAmerica 21

Question: Write a single SQL query that, for each pair of actors, lists their two actor_ids...

Question: Write a single SQL query that, for each pair of actors, lists their two actor_ids and the number of films in which both actors appeared. DATABASE SCHEMA CREATE TABLE actor ( actor_id INTEGER, first_name TEXT, last_name TEXT); CREATE TABLE film ( film_id INTEGER, title TEXT, description TEXT, length INTEGER); CREATE TABLE film_actor ( actor_id INTEGER, film_id INTEGER);

Write a SQL query to find the movie Title that has received Lowest rating from reviewers,...

Write a SQL query to find the movie Title that has received Lowest rating from reviewers, but whose actors have received an award for their contribution in movie. Output: Fantastic Beasts and Where to Find Them // THE DATABASE // DROP DATABASE IF EXISTS cs431_movie_database; CREATE DATABASE cs431_movie_database; USE cs431_movie_database; CREATE TABLE `artists` ( `artist_id` INT NOT NULL AUTO_INCREMENT, `first_name` varchar(45) NOT NULL, `last_name` varchar(45) NOT NULL, `contact_no` varchar(15) DEFAULT NULL, `Profession` TEXT DEFAULT NULL, `birth_date` datetime DEFAULT NULL,...

Question