2) The town of Harmonia gives away all 500 tickets to its an…

2) The town of Harmonia gives away all 500 tickets to its annual Founder’s Day Free Concert-in-the-Park to local residents. Each year, more than 500 people wish to attend the concert, so some of the residents who receive the free tickets sell them for as much as $75 each. Is a transaction where someone pays a resident $75 for a “free ticket” economically efficient?

Which of the following queries returns the same output as th…

Which of the following queries returns the same output as the query below?   SELECT c.customer_id, c.first_name , c.last_name , c.phoneFROM salestransactions AS sINNER JOIN customers AS  c ON c.customer_id=s.customer_idINNER JOIN productsinfo AS  p ON p.product_id=s.product_idWHERE p.product_type=’automobile’  AND c.phone IS NOT NULL ;