[HW 3.3c] SQL Basics – Part 1

Using the data set that we connected to in class, please prepare the following in SQL:

1. The records of those employees in region 2
2. A list of all employees, by manager
3. The names of the first 20 customers in region 3, alphabetized from A to Z.
4. The names and msrp of all products with a msrp less than or equal to  3
5. The sum of all transaction amounts for the month of February 2013
6. The total number of transactions in June 2013

Turn in your SQL statements and the output it produced.

Advertisements

4 comments

  1. barroyo2015 · · Reply

    How does one ‘sum’ transaction amounts?

    Like

  2. barroyo2015 · · Reply

    jk figured it out

    Like

  3. Jason, what can be the source of the problem when I try to group employees by manager, SQL only gives out 5 people.

    Like

  4. try using ORDER BY at the bottom, instead of GROUP BY

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: