15.Count all the vendor contact first names, then count all the distinct vendor contact first names....

Question

Question

15.Count all the vendor contact first names, then count all the distinct vendor contact first names....

15.Count all the vendor contact first names, then count all the distinct vendor contact first names. Finally find the vendor contact first names that exist more than once. in sql quries

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

15.
Count all the vendor contact first names,
select count(first_name)
from vendors

count all the distinct vendor contact first names.
select count(distinct first_name)
from vendors

find the vendor contact first names that exist more than once. in sql quries
   select first_name
   from vendors
   group by first_name
   having count(first_name) > 1

Add a comment

Answer 2

Similar Homework Help Questions

Hi this is for SQL Use the AP database Vendor name from the vendor table Vendor...

Hi this is for SQL Use the AP database Vendor name from the vendor table Vendor Contact First Name and Vendor Contact Last Name from the vendor table but I need them concatenated together with a space between the names Invoice Date from the invoice table Only the day of from the Invoice Date Invoice Number from the invoice table The third and fourth characters from the Invoice Number Line Item Amount from the invoice line items table Calculate the...
Write SQL code please. Tables are attached with their appropriate fields for reference. The Marketing Department...

Write SQL code please. Tables are attached with their appropriate fields for reference. The Marketing Department requires a vendor listing that shows the following fields: 1. - Vendor Name Vendor Contact First Name - Vendor Contact Last Name - Vendor City - Vendor State - Vendor Zip Code Note: Sort by vendor state The Finance Department requires a report that shows payment totals greater than $50.00. List the following fields 2. - Vendorid - Payment Total - Payment Date The...
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)

write a ContactBook in C++ ContactBook that holds 10 names with that names corresponding contact (last...

write a ContactBook in C++ ContactBook that holds 10 names with that names corresponding contact (last name and first name of the owner). Ask the user to input up to 10 Contacts (It may be less. The user should have the ability to stop inputting Contacts whenever he wishes). 3.This class will store a list of Contacts in a stack allocated array of default capacity 10. 4.You must be able to add new contacts to a list, delete old contacts,...
Write a query to find all product names from Production.Product table. with the list price greater...

Write a query to find all product names from Production.Product table. with the list price greater than $3,000. Use SQL select statement.
In Java. Write a GUI contact list application. The program should allow you to input names...

In Java. Write a GUI contact list application. The program should allow you to input names and phone numbers. You should also be able to input a name and have it display the previously entered phone number. The GUI should look something like the following, although you are welcome to format it in any way that works. This should be a GUI application with a JFrame. The program should contain two arrays of Strings. One array will contain a list...

The following SQL query returns one row per surgeon. The granularity before GROUP BY is a surgeon-panel combination, in...

The following SQL query returns one row per surgeon. The granularity before GROUP BY is a surgeon-panel combination, in other words, for each surgeon, one panel they performed in. Surgeons can only be listed once per panel, but a log can have more than one panel. SELECT staff.STAFF_NM_WID "surgeon", COUNT( orl.LOG_ID ) "Number of Logs" FROM OR_LOG orl INNER JOIN V_LOG_STAFF staff ON orl.LOG_ID = staff.LOG_ID INNER JOIN OR_LOG_ALL_PROCS procs ON orl.LOG_ID = procs.LOG_ID AND procs.LINE = 1 --First Listed...
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...
Form A Mid-Term Exam In ajoin, when using the ON keyword, column names need to be...

Form A Mid-Term Exam In ajoin, when using the ON keyword, column names need to be qualified only A in inner joins B. in outer joins c when the code is confusing D. when the same column names exist in both tables 7. Referring to the following code example and the data model the total number of rows returned by this query must equal SELECT vendor name, Invoice number FROM invoices LEFT JOIN vendors ON Invoices. vendor id = vendors.vendor...

Here is the UML for the class Contact -fullName : string -phoneNum: string -emailAddress : string...

Here is the UML for the class Contact -fullName : string -phoneNum: string -emailAddress : string +Contact() //default constructor sets all attribute strings to “unknown”; no other constructor +setName(string name) : void +setPhone(string pn) : void +setEmail(string em) : void +getName() : string +getPhone() : string +getEmail() : string +printContact() : void //print out the name, phone numbers and email address Create New Project Name your project: CIS247_Lab7_YourLastName. For this exercise, you may use a header file or one file...

15.Count all the vendor contact first names, then count all the distinct vendor contact first names....

Homework Answers

Add Answer to:
15.Count all the vendor contact first names, then count all the distinct vendor contact first names....

Post as a guest

Earn Coins

Hi this is for SQL Use the AP database Vendor name from the vendor table Vendor...

Write SQL code please. Tables are attached with their appropriate fields for reference. The Marketing Department...

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

write a ContactBook in C++ ContactBook that holds 10 names with that names corresponding contact (last...

Write a query to find all product names from Production.Product table. with the list price greater...

In Java. Write a GUI contact list application. The program should allow you to input names...

The following SQL query returns one row per surgeon. The granularity before GROUP BY is a surgeon-panel combination, in...

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

Form A Mid-Term Exam In ajoin, when using the ON keyword, column names need to be...

Here is the UML for the class Contact -fullName : string -phoneNum: string -emailAddress : string...

15.Count all the vendor contact first names, then count all the distinct vendor contact first names....

Homework Answers

Add Answer to: 15.Count all the vendor contact first names, then count all the distinct vendor contact first names....

Post as a guest

Earn Coins

Add Answer to:
15.Count all the vendor contact first names, then count all the distinct vendor contact first names....