Database SQL query Job Interview Questions

by D. Lawton Published On 5/20/2011 |

Category: Interviewing

Tell-A-Friend |

Jobs |

Job Tools |

Career Surveys |

Discussions

Database SQL query Job Interview Questions job interview questions have been compiled to prepare for you for your next job interview. Research these questions thoroughly and prepare accurate and concise answers.

List the company names in the CUSTOMER table that contain the word "Computer".
Determine how many states have at least one customer residing in them.
List the offices (that is, OFFICE.CITY) and invoice totals for each office, from the largest total to the smallest. Use the following tables; OFFICES, INVOICES, SALESMAN.
List the part numbers, descriptions, total units and dollar sold for fast moving parts (defined as those parts with more than 50 invoiced units. Use tables Detail, Parts.
List the companies that purchased more that one Woodyard Lizard, the total purchased, and the total amount paid. Use tables Customers, Parts, Invoices, Detail.
List companies that have an 'x' in the third position of their company name.
List the company, city, and state for customers located in the same city as one of the offices.
List the descriptions of parts invoiced to customers in the state of New York(NY).
List the pairs of part numbers and descriptions for which both parts were invoiced to the same customer.
List the states in which at least one customer is located above 45 degree latitude.
List companies with no invoices.
List states in which every customer has an invoice.
Given the following commission schedule, calculate commissions on the sales in INVOICES by salesperson, showing the sales persons, name, total sales, and commission. Display the information in ascending order. 10% 1st $5000 9% 2nd $5000 8% 3rd $5000 6% above $15000
List the sales people whose YTD sales are more than 10% above the average YTD sales.
List all customers with more than one invoice.
Show all data on invoices dated between May 17, 2003 and May 23, 2003.
Show any offices, together with their city, and state, that have year-to-date sales exceeded by those of some individual salesperson.
Show any offices, together with their city, and state, that have year-to-date sales greater than all individual salesperson.