Reference no: EM1350402
Q1) Perform the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-free, copy and paste your statements into this assignment document. Upload this Word document for grading.
All questions should be answered with one SQL statement. Use the new Join syntax.
1. Find the columns that make up the primary key of the l_lunch_items table. Sort the columns by position. (Do this in one statement).
2. List all the lunches that employees have signed up for. Show me first_name, last_name, lunch_date, and product_code of the items they ordered. Do not include employees who don't have a manager.
Sort the rows by product_code.
3. From the employees table, list the employee_id, last_name, and phone_number of every employee, along with the last_name and phone number of his manager. Sort the rows by employee_id. (Hint...tables can be joined to themselves...just give each table a different alias).
4. Similar to 3, but include rows for the people who do not have managers.
5. Count the number of foods supplied by each supplier. List all the suppliers. Show the supplier_id, supplier_name, and number of foods from each supplier. Sort the rows on the supplier_id.
6. Count the number of employees who work in each department. List all the departments. Show the department code, department name, and the number of employees. Sort on the dept_code.
|
Treatment of a sensorimotor disorder
: I need assistance regarding the treatment of a sensorimotor disorder. Can you compare and contrast the different approaches to treating the disorder that can be identified as it relates to its effectiveness of treatment?
|
|
Recruiting motivation and managerial actions
: Write Walter's parents, stressing that the scholarship will cover all of his tuition, room and board, and book expenses.
|
|
Principle motives for holding cash-near cash assets
: Briefly identify and explain the principle motives for holding cash and near cash assets. What are the risk-return trade-off associated with inventory management?
|
|
What is the potential energy of the system
: At the instant the alpha particle leaves the nucleus, the centers of the two are 7.5 apart and essentially at rest. Find their speeds while they're a great distance apart. Treat each particle as a spherical charge distribution.
|
|
Determine columns that make up the primary key
: Carry out the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Determine the columns that make up the primary key of the l_lunch_items tabl..
|
|
Explain what value would it be to know were going
: Explain What value would it be to know that you were going to be training a class of persons between the ages of 20 and 35?
|
|
Determine additional funds needed
: Suppose that Marbell Corporation is operating below capacity, calculate the amount of new funds required to finance this growth. Marbell has an 8 percent return on sales and 70 percent is paid out as dividends.
|
|
Mental-physical and spiritual health
: How realistic is it to expect health care workers to model mental, physical, and spiritual health? If Americans tend to be overweight, underactive workacoholics who experience burnout, why should health care workers be any different?
|
|
Individual motivations - case studies
: Eval whether the individuals will be motivated to behave as desired. Then select the appropriate managerial action from those listed.
|