Please help and list all information that should be used in the query.................

CASE BACKGROUND

MGMT Boutique Inc. is a high$-$end retailer that operates a chain of boutique stores in major hotel properties along the west coast of Barbados, including the famous five$-$diamonds Sandy Lane Hotel. Operating in eleven $(11)$ locations, the company offers chic brands like Roberto Cavalli, Pain$-$de$-$Sucre, Versace, and Etro Milano, to name a few, and is well known for an eclectic collection of designer swimwear, fine linens, cotton and silk apparel for warm days and sultry evenings. A fine complement of shoes, hats and handbags with hand$-$picked custom jewelry are included to embrace the very essence of luxurious fashion. The locations connect over a MetroE$-$wide area network $($WAN$)$ that FLOW provides. Each store has a local Point$-$of$-$Sale $($POS$),$ replicated to a central hub in the main office. Replication occurs once every $15$ minutes, so the head office is virtually up$-$to$-$date, in real$-$time, and can see, at a glance, transactions in each store. Customers primarily shop duty$-$free, paying in either Barbados $($BDS$)$ or USA dollars. Duty$-$free sales do not attract a $15\mathrm{.}0\%$ VAT tax. The list price, seen on the shelf, is the price paid. For customer convenience, the company offers a limited range of duty$-$paid items. Again, customers can pay in either currency or the price listed on the self is still the price paid. However, this price now includes $15\mathrm{.}0\%$ VAT. Customers pay by cash or card, charge the expense to their room, and settle the bill later. As a reporting requirement for a duty$-$free establishment, POS details for customers are routinely captured. This information has proven helpful for analyzing behavior, and the company also tries to capture the exact details of duty$-$paid transactions. As a rule, duty$-$free transactions will be done in US dollars, while duty$-$paid transactions will appear in BDS dollars.

Create the following queries using the correct tables:

a$.$ List the names of places from which the company sells. Show all columns in the table. Name this query Q$1-$SELLING$-$LOCATIONS.

b$.$ What is the total sales by location for May $2008,$ sorted in descending order? Name this query Q$2-$SALES$-$MAY$2008.($Hint: $$Where$$ clause may be useful$)$

c$.$ The company has been informed that the tax has been increased to $17\mathrm{.}5\%.$ Calculate how much additional tax $($i$.$e$.,$ the difference$)$ the store would have collected by year. Name this query Q$3$ ADDED$-$TAX.