Reference no: EM13165138

Test the database design by running the following queries on one of the tables. You must submit the returned results for each query.

You can use my table as an example. My table consists of this:

CUSTOMER: First name,Last Name, Address, Home phone, Cell phone and email address.

( just give me examples or syntax of how to query this table? you can use my table or use examples, which ever you like. just want the syntax.)

query specifying specific columns

query using a column alias

query using the concatenation operator

query using a literal character string

query eliminating duplicate rows

query using the where clause and a comparison operators

query using the BETWEEN operator

query using the IN(LIST) operator

query using the LIKE operator

query using the IS NULL operator

query using the AND operator

query using the OR operator

query using the NOT operator

query using the ORDER BY clause ascending or descending

query where output is sorted by column alias

query that is sorted by multiple columns

query involving an equijoin

query involving an outer join

query involving a self join

query involving the NVL function

query involving the DECODE function

query involving the SUBSTR function

query involving the INSTR function

query involving the UPPER function

query involving the LOWER function

query involving the LPAD function

query involving the RPAD function

query involving the MONTHS_BETWEEN function

query involving the HAVING clause

query involving the Group by clause

query involving the count function