Get the name of buyers with the names of thesupermarkets they bought items in?What is the name and address ofcustomers who bought a coat or perfume?Change Location to "Ahsaa" forsupermarket which name is "Danoub"..Create a view that shows the codeand the name of all supermarketsthat located in Dammam or Riyadh? SCodeMS3B1W6PR1MS4E11SupermarketSCodeMS3B1SnamePandaDanoubLULUDanoubTamimiPandaCnameSaudHalaFahadHessaNouraSultanW6PR1MS4E11CustomerAge Sex Address18M62F45 M742930BuyCNameSaudHalaaFahadHessaNouraSultanLocationRiyadhAbhaRiyadhRiyadhDammamDammamFFM11 street127 street11 streetItemCoatScarfShoesSocksPerfumeBookTypeClothesChemistGeneralClothesClothesBooksCost35.0010.0030.001.5018.002.50

Join the Buy and Supermarket table to get supermarket name where item is bought.SELECT CName, Sname…

Get the name of buyers with the names of the supermarkets they bought items in? What is the name and address of customers who bought a coat or perfume? Change Location to "Ahsaa" for supermarket which name is "Danoub".. Create a view that shows the code and the name of all supermarkets that located in Dammam or Riyadh?

Get the name of buyers with the names of the supermarkets they bought items in? What is the name and address of customers who bought a coat or perfume? Change Location to "Ahsaa" for supermarket which name is "Danoub".. Create a view that shows the code and the name of all supermarkets that located in Dammam or Riyadh?

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

What did you take away from the process of creating your religion characteristics table?
Task 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.
Select the query that properly uses table aliases to show the genres of each track in the Album with the id of 6. SELECT genre.name, track.nameFROM trackJOIN genreUSING (genre_id)WHERE track.album_id=6; SELECT g(name), t(name)FROM track AS tJOIN genre AS gUSING (genre_id)WHERE t(album_id)=6; SELECT g.name, t.nameFROM t AS trackJOIN g AS genreUSING (genre_id)WHERE t.album_id=6; SELECT g.name, t.nameFROM track AS tJOIN genre AS gUSING (genre_id)WHERE t.album_id=6;
Please give me correct solution.
The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals.
Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.
The Colonial Adventure Tours database will be used. How many bookings have a travel cost of more than $20 but less than $75?
Create a table with customer names, ID and cities. Create a view of the table where entry is a particular city for example, Columbia.
The code I have written is what I have so far, I guess we would use a nested query but Im not sure how to approach that.
Q19) List all product rows (including the ones that have no matching vendors) and all matchingvendor rowsQ20) 2What product(s) have the highest inventory value (P_QOH * P_PRICE)Q21)?What products have a price that exceeds the average product priceQ22) 2What is the average price for each sale codeQ23) ?What is the average product price
How many of these 1,000 customers (1) have a salary at least $90,000 and spent at least $1,700 or (2) have a salary no greater than $100,000 and spent no more than $1,800? (Hint: Create one or more new columns.)