ive got the answer for the first 3 questions please answer the remaining 2 questions which is question 4 and 5 1. List Godaloct and Description for Stock.2. List Godhaleck and sales representative for description which started with ietter C.3. List sales representative and area for sales representative In Ampang area and Selayang4. List description and location for goods sold by Bal Hu5. List GodhalockRkaRA and sales representative which sels soya bean juice. атокCode stockDescriptionagentLocationKeropokPoh HuaB011KepongA001Ikan BlisMimiAmpangB511Coca-ColaAzmSelayangCI KeringAir SoyaD401LIzaPuchongA023KhairulAmpangJUALANSell CodeCode stockSell dateBuy_PriceSel PriceQuantityM33AD0118/04/02O.801.3035M23A0231905/021.502.3020L02B51123/04/020.801.4090B01413/02/020.601.203L13D40102/02/020.750.9050

SQL queries have been used as nothing has been specified.

Answered: 4. List description and location for…

4. List description and location for goods sold by Bo. tuat 5. List GodsRloctRR and sales representative which selis soya bean juice.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

The solutions provided didn't work for any of the questions. Please provide different solutions for the 3 questions
Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To decrease the postal costs, they will send gifts to owners in batches to their corresponding offices. Similarly, the marketing team will send the gifts in groups to the residents living in the same property. Therefore, you will need to provide them the number of gifts for each StayWell office and number of gifts for each property. The column headers for the first table should be OFFICE_NUM and GIFTS, the column headers for the second table should be PROPERTY_ID and GIFTS.
Alert dont submit AI generated answer.
(please give correct answer with explanation).
In cell K1, enter a formula using the MAXIFS function to find the NO. Participants where the cost is $15 in the city of Atlanta.
Determine which types of books are currently available in the current inventory. Each category should only be included once.
7. What gift will a customer who orders the book Shortest Poems receive? Use the actualbook retail value to determine the gift.
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
Determine the kind of books in the library's current collection. Each category should include just a single entry.
I requested the key for 1, not -5.
On the Faculty Data worksheet, in cell J3, use an IFS function to calculate the retirement matching dollar amount for each faculty member participating in the retirement plan. If the participating member is a Full Professor, the matching amount is 4% of the salary. Otherwise, the matching amount is 3% of the salary. If the member is not participating, show a blank.
The following list shows the items and prices for a restaurant order. Calculate the total amount if there is 7.5% tax and the customer leaves a 15% gratuity. 1 appetizer: $8.99 2 entrees: $14.99 each 1 entree: $12.99 3 drinks: $1.99 each a. $70.96 b. $71.62 c. $75.31 d. $75.97 Please select the best answer from the choices provided A Mark this and retum No hand written and fast answer with explanation