Create a new scheme called hollywood

  a. login to system account

  b. Start the script hollywoodschema.sql

 

2. Load DB

   a. login to hollywood account with 'password'

   b. Start the script hollywoodnorthcreatetables.sql

   c. Start the script populatehollywoodnorth.sql

 

 

How do you prepare a template? It suppose to look something like this

-- Solution for Question 1

    -- Your script for question 1 here

-- Solution for Question 2

    -- Your script for question 2 here

 

 

They're supposed to be five questions. I know what the questions are going to be about but I don't know what he's going to be asking for. 

One question will ask for something for one of these. Can you tell me step by step on how to do each one? 

1. Simple queries
2. Join-based queries
3. Single-row functions queries
4. Group functions queries
5. Subqueries
    

Basically he will give us a table I do like this 

 

 

The tables could be small or as big as this and there could be one to three tables for each question. We have to use the three SQL files that he told us to populate to find answers for each of the five topics above. There will be five questions, one question will be asking for one of the five.

 

 

 

Also these are tips for success. How do I use these? Can you show screenshots when using this in Oracle SQL

 

Tips for Success

1. Use column aliases to create appropriate column headers.

 

2. Use set linesize xxx, where xxx is a number to set the width for the output.

 

3. Use a column command to set the size of the columns, e.g.:

column "aliasname" format A40

column "stagename" format A30

"A" means alphanumeric field, with a length of 30 characters in the example above.

 

4. For number columns use:

column "aliasname" format 9999.99

This will show four digits before the decimal point and two digits after the decimal point.

 

5. Use clear columns; at the end of each query to reset the column size.

 

6. Use the following format for breaks:

break on columnname/alias [on columnname/alias]

 

Tour Paris Highlights France in 4 Days European Vacation Paris Culture Tour Sights of Barcelona Palm Springs Adventure Palm Springs Highlights Calgary Adventure Rocky Mountain Experience 9 rows selected. # of destinations 4 4 5 4 4 4 445 4 Total $370.63 $748.41 $1,299.47 $792.90 $917.43 $1,390.45 $336.17 $467.87 $1,100.60