Share
Explore BrainMass

SQL Queries

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.

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 ...

Solution Summary

This solution deals with a set of 5 SQL queries based on DDL and DML statements

$2.19