Consider the following three tables, primary and foreign keys.

Table Name        SalesPeople

Attribute Name                                Type                                      Key Type

EmployeeNumber             Number                               Primary Key

Name                                   Character

JobTitle                                  Character           

Address                                 Character

PhoneNumber                     Character

YearsInPosition                             Number

Table Name        ProductDescription

Attribute Name                                Type                                      Key Type

                ProductNumber                Number                               Primary Key

                ProductName                  Character           

                ProductPrice                   Number

Table Name        SalesOrder

Attribute Name                                Type                                      Key Type

                SalesOrderNumber        Number                               Primary Key

                ProductNumber               Number                               Foreign Key

                EmployeeNumber           Number                               Foreign Key

                SalesOrderDate                Date

Assume that you draw up a new sales order for each product sold.

Develop the following queries in SQL:

a.       All the Sales People with less than four years in position.  

b.      All the Product Names sold on April 4^th.  

c.       All the Products sold by Sales People less than 3 years in the position.  

write a sql statement that retrieves product ID (ProductID) and name (Name) from Production.product table for all product whose name includes both the words "silver" and "frame"

1. How do I write a query that displays the name (concatenate the first name, middle initial, and last name), date of birth, and age for all students? Show the age with no decimal places, and only include those students who are 21 or older. Order by age, as shown below: (Hint: Use the TRUNC function. The ages may be different, depending on the date that the query is run.)

SELECT S_FIRST || ' ' || S_MI || ' ' || S_LAST AS "student name"
from STUDENT;

WHERE .....

Here is the query 1 result bellow

Full Name Date of birth Age

1. Brian D. Umato 1 9-AUG-98 21

2. Amanda J. Mobley 24-SEP- 96 22

3. Daniel . Black 10-OCT-94 24

Query 2. Employees table

Using the EMPLOYEES table, display the email, phone number, and then one other column (the name of the column is entered by the user). This same column is then also used in the ORDER BY clause to order the resulting rows. Restrict the rows to those that are equal to a certain department id (this number is also entered in by the user.) Use the double ampersand for the column substitution variable to insure that the user is prompted to enter the column name ONLY ONCE, and that it is “cleared out” after the run (UNDEFINE).

I just need a little solution thanks.

Name the body system composed of hormone producing structures:

Name the body system that generates movement and heat

In Java, Here is a basic Name class. class Name { private String first; private String last; public Name(String first, String last) { this.first = first; this.last = last; } public boolean equals(Name other) { return this.first.equals(other.first) && this.last.equals(other.last); } } Assume we have a program (in another file) that uses this class. As part of the program, we need to write a method with the following header: public static boolean exists(Name[] names, int numNames, Name name) The goal of the method is to see whether the given name exists in names. If yes, return true; if not, return false. (Use the equals method.) Note that names might not be full, so numNames tells us how many Names are stored in the array and therefore how far in the array we should search. (In other words, it could be that names.length > numNames.) Write this method.

Create a table with two columns. Name the table First Initial _ Last Name (e.g. John Dow will create table j_dow). You have to audit all DML statements on your table. To do this you write two triggers: 1. To log any DML statements that users might run on this table. The results must be stored in the First Initial _ Last Name _ Log table (e.g. John Dow will create table j_dow_log). The table should have unique event ID, values for both the Oracle and the system user who ran the query, the time it was executed and the type of DML query user ran. 2. To capture any data that was changed in the table. The results must be stored in the First Initial _ Last Name _ History table (e.g. John Dow will create table j_dow_history). The table should reference the event ID from the log table, and store both old and new values for both columns.

Question 1:

Name three actual species by scientific name and classify then according to species, genus, family, order, class, phylum, kingdom, and domain. At what point do your organisms share a common ancestor? Which pair of species is more closely related to each other than to the third species?

Name and describe the 5 morphological traits that almost all primates have with human beings

Name and describe the 3 main behavioral traits that almost all primates have with humans

Consider the following three tables, primary and foreign keys.

Table Name        SalesPeople

Attribute Name                                Type                                      Key Type

EmployeeNumber             Number                               Primary Key

Name                                   Character

JobTitle                                  Character           

Address                                 Character

PhoneNumber                     Character

YearsInPosition                             Number

Table Name        ProductDescription

Attribute Name                                Type                                      Key Type

                ProductNumber                Number                               Primary Key

                ProductName                  Character           

                ProductPrice                   Number

Table Name        SalesOrder

Attribute Name                                Type                                      Key Type

                SalesOrderNumber        Number                               Primary Key

                ProductNumber               Number                               Foreign Key

                EmployeeNumber           Number                               Foreign Key

                SalesOrderDate                Date

Assume that you draw up a new sales order for each product sold.

Develop the following queries in SQL:

a.       All the Sales People with less than four years in position.

b.      All the Product Names sold on April 4^th.

c.       All the Products sold by Sales People less than 3 years in the position.