SQL Queries
Not what you're looking for?
Use only one SQL statement for each task. Submit the SQL statement(s) that you would use to accomplish each task.
1.Find all employees whose name starts with either an S, s, A, a, T, or t. List all information about each employee in the output. (Though our table does not contain lower cases, your SQL should work even if there were lower cases.) You must use either LOWER or UPPER function.
2.Find all orders not placed during the first quarter (Jan-Mar). (Use to_char or like.)
5.Find the total number of products sold for each product.
6.Find the average order dollar total amount across all orders.
7.What is the average sale price (acutalprice in item table) for all products with 'ACE' in their descriptions. You should return one number as the answer.
Purchase this Solution
Solution Summary
This solution deals with a set of 5 SQL queries based on DDL and DML statements
Solution Preview
Hi,
Given below are the queries for your questions:
Use only one SQL statement for each task. Submit the SQL statement(s) that you would use to accomplish each task.
1.Find all employees whose name starts with either an S, s, A, a, T, or t. List all information about each employee in the output. (Though our table does not contain lower cases, your SQL should work even if there were lower ...
Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
C++ Operators
This quiz tests a student's knowledge about C++ operators.