target-benchmark/spider-queries huggingface dataset:
Database: customer_complaints (tables: complaints, staff)
Question: Return the first names of the 5 staff members who have handled the most complaints.
SQL: SELECT t1.first_name FROM staff AS t1 JOIN complaints AS t2 ON t1.staff_id  =  t2.staff_id GROUP BY t2.staff_id ORDER BY count(*) LIMIT 5
Database: customer_complaints (tables: customers)
Question: Which state has the most customers?
SQL: SELECT state FROM customers GROUP BY state ORDER BY count(*) LIMIT 1
Database: customer_complaints (tables: customers)
Question: Give the state that has the most customers.
SQL: SELECT state FROM customers GROUP BY state ORDER BY count(*) LIMIT 1
Database: workshop_paper (tables: submission)
Question: How many submissions are there?
SQL: SELECT count(*) FROM submission
Database: workshop_paper (tables: submission)
Question: Count the number of submissions.
SQL: SELECT count(*) FROM submission
Database: workshop_paper (tables: submission)
Question: List the authors of submissions in ascending order of scores.
SQL: SELECT Author FROM submission ORDER BY Scores ASC
Database: workshop_paper (tables: submission)
Question: Find the author for each submission and list them in ascending order of submission score.
SQL: SELECT Author FROM submission ORDER BY Scores ASC
Database: workshop_paper (tables: submission)
Question: What are the authors of submissions and their colleges?
SQL: SELECT Author ,  College FROM submission
Database: workshop_paper (tables: submission)
Question: For each submission, show the author and their affiliated college.
SQL: SELECT Author ,  College FROM submission
Database: workshop_paper (tables: submission)
Question: Show the names of authors from college "Florida" or "Temple"
SQL: SELECT Author FROM submission WHERE College  =  "Florida" OR College  =  "Temple"
Database: workshop_paper (tables: submission)
Question: Which authors with submissions are from college "Florida" or "Temple"?
SQL: SELECT Author FROM submission WHERE College  =  "Florida" OR College  =  "Temple"
Database: workshop_paper (tables: submission)
Question: What is the average score of submissions?
SQL: SELECT avg(Scores) FROM submission
Database: workshop_paper (tables: submission)
Question: Compute the average score of submissions.
SQL: SELECT avg(Scores) FROM submission
Database: workshop_paper (tables: submission)
Question: What is the author of the submission with the highest score?
SQL: SELECT Author FROM submission ORDER BY Scores DESC LIMIT 1
Database: workshop_paper (tables: submission)
Question: Find the author who achieved the highest score in a submission.
SQL: SELECT Author FROM submission ORDER BY Scores DESC LIMIT 1
Database: workshop_paper (tables: submission)
Question: Show different colleges along with the number of authors of submission from each college.
SQL: SELECT College ,  COUNT(*) FROM submission GROUP BY College
Database: workshop_paper (tables: submission)
Question: For each college, return the college name and the count of authors with submissions from that college.
SQL: SELECT College ,  COUNT(*) FROM submission GROUP BY College
Database: workshop_paper (tables: submission)
Question: Show the most common college of authors of submissions.
SQL: SELECT College FROM submission GROUP BY College ORDER BY COUNT(*) DESC LIMIT 1
Database: workshop_paper (tables: submission)
Question: Which college has the most authors with submissions?
SQL: SELECT College FROM submission GROUP BY College ORDER BY COUNT(*) DESC LIMIT 1
Database: workshop_paper (tables: submission)
Question: Show the colleges that have both authors with submission score larger than 90 and authors with submission score smaller than 80.
SQL: SELECT College FROM submission WHERE Scores  >  90 INTERSECT SELECT College FROM submission WHERE Scores  <  80
Database: workshop_paper (tables: submission)
Question: Which colleges have both authors with submission score above 90 and authors with submission score below 80?
SQL: SELECT College FROM submission WHERE Scores  >  90 INTERSECT SELECT College FROM submission WHERE Scores  <  80
Database: workshop_paper (tables: acceptance, submission)
Question: Show the authors of submissions and the acceptance results of their submissions.
SQL: SELECT T2.Author ,  T1.Result FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID
Database: workshop_paper (tables: acceptance, submission)
Question: For each submission, find its author and acceptance result.
SQL: SELECT T2.Author ,  T1.Result FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID
Database: workshop_paper (tables: acceptance, submission)
Question: Show the result of the submission with the highest score.
SQL: SELECT T1.Result FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID ORDER BY T2.Scores DESC LIMIT 1
Database: workshop_paper (tables: acceptance, submission)
Question: Which submission received the highest score in acceptance result. Show me the result.
SQL: SELECT T1.Result FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID ORDER BY T2.Scores DESC LIMIT 1
Database: workshop_paper (tables: acceptance, submission)
Question: Show each author and the number of workshops they submitted to.
SQL: SELECT T2.Author ,  COUNT(DISTINCT T1.workshop_id) FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID GROUP BY T2.Author
Database: workshop_paper (tables: acceptance, submission)
Question: How many workshops did each author submit to? Return the author name and the number of workshops.
SQL: SELECT T2.Author ,  COUNT(DISTINCT T1.workshop_id) FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID GROUP BY T2.Author
Database: workshop_paper (tables: acceptance, submission)
Question: Show the authors who have submissions to more than one workshop.
SQL: SELECT T2.Author FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID GROUP BY T2.Author HAVING COUNT(DISTINCT T1.workshop_id)  >  1
Database: workshop_paper (tables: acceptance, submission)
Question: Which authors have submitted to more than one workshop?
SQL: SELECT T2.Author FROM acceptance AS T1 JOIN submission AS T2 ON T1.Submission_ID  =  T2.Submission_ID GROUP BY T2.Author HAVING COUNT(DISTINCT T1.workshop_id)  >  1
Database: workshop_paper (tables: workshop)
Question: Show the date and venue of each workshop in ascending alphabetical order of the venue.
SQL: SELECT Date ,  Venue FROM workshop ORDER BY Venue
Database: workshop_paper (tables: workshop)
Question: Sort the each workshop in alphabetical order of the venue. Return the date and venue of each workshop.
SQL: SELECT Date ,  Venue FROM workshop ORDER BY Venue
Database: workshop_paper (tables: acceptance, submission)
Question: List the authors who do not have submission to any workshop.
SQL: SELECT Author FROM submission WHERE Submission_ID NOT IN (SELECT Submission_ID FROM acceptance)
Database: workshop_paper (tables: acceptance, submission)
Question: Which authors did not submit to any workshop?
SQL: SELECT Author FROM submission WHERE Submission_ID NOT IN (SELECT Submission_ID FROM acceptance)
Database: tracking_share_transactions (tables: investors)
Question: Find the number of investors in total.
SQL: SELECT count(*) FROM INVESTORS
Database: tracking_share_transactions (tables: investors)
Question: Show all investor details.
SQL: SELECT Investor_details FROM INVESTORS
Database: tracking_share_transactions (tables: lots)
Question: Show all distinct lot details.
SQL: SELECT DISTINCT lot_details FROM LOTS
Database: tracking_share_transactions (tables: transactions)
Question: Show the maximum amount of transaction.
SQL: SELECT max(amount_of_transaction) FROM TRANSACTIONS
Database: tracking_share_transactions (tables: transactions)
Question: Show all date and share count of transactions.
SQL: SELECT date_of_transaction ,  share_count FROM TRANSACTIONS
Database: tracking_share_transactions (tables: transactions)
Question: What is the total share of transactions?
SQL: SELECT sum(share_count) FROM TRANSACTIONS
Database: tracking_share_transactions (tables: transactions)
Question: Show all transaction ids with transaction code 'PUR'.
SQL: SELECT transaction_id FROM TRANSACTIONS WHERE transaction_type_code  =  'PUR'
Database: tracking_share_transactions (tables: transactions)
Question: Show all dates of transactions whose type code is "SALE".
SQL: SELECT date_of_transaction FROM TRANSACTIONS WHERE transaction_type_code  =  "SALE"
Database: tracking_share_transactions (tables: transactions)
Question: Show the average amount of transactions with type code "SALE".
SQL: SELECT avg(amount_of_transaction) FROM TRANSACTIONS WHERE transaction_type_code  =  "SALE"
Database: tracking_share_transactions (tables: ref_transaction_types)
Question: Show the description of transaction type with code "PUR".
SQL: SELECT transaction_type_description FROM Ref_Transaction_Types WHERE transaction_type_code	  =  "PUR"
Database: tracking_share_transactions (tables: transactions)
Question: Show the minimum amount of transactions whose type code is "PUR" and whose share count is bigger than 50.
SQL: SELECT min(amount_of_transaction) FROM TRANSACTIONS WHERE transaction_type_code  =  "PUR" AND share_count  >  50
Database: tracking_share_transactions (tables: transactions)
Question: Show the maximum share count of transactions where the amount is smaller than 10000
SQL: SELECT max(share_count) FROM TRANSACTIONS WHERE amount_of_transaction  <  10000
Database: tracking_share_transactions (tables: transactions)
Question: Show the dates of transactions if the share count is bigger than 100 or the amount is bigger than 1000.
SQL: SELECT date_of_transaction FROM TRANSACTIONS WHERE share_count  >  100 OR amount_of_transaction  >  1000
Database: tracking_share_transactions (tables: transactions, ref_transaction_types)
Question: Show the transaction type descriptions and dates if the share count is smaller than 10.
SQL: SELECT T1.transaction_type_description ,  T2.date_of_transaction FROM Ref_Transaction_Types AS T1 JOIN TRANSACTIONS AS T2 ON T1.transaction_type_code  =  T2.transaction_type_code WHERE T2.share_count  <  10
Database: tracking_share_transactions (tables: transactions, investors)
Question: Show details of all investors if they make any transaction with share count greater than 100.
SQL: SELECT T1.Investor_details FROM  INVESTORS AS T1 JOIN TRANSACTIONS AS T2 ON T1.investor_id  =  T2.investor_id WHERE T2.share_count  >  100
Database: tracking_share_transactions (tables: transactions)
Question: How many distinct transaction types are used in the transactions?
SQL: SELECT COUNT(DISTINCT transaction_type_code) FROM TRANSACTIONS
Database: tracking_share_transactions (tables: lots)
Question: Return the lot details and investor ids.
SQL: SELECT lot_details ,  investor_id FROM LOTS
Database: tracking_share_transactions (tables: lots, investors)
Question: Return the lot details of lots that belong to investors with details "l"?
SQL: SELECT T2.lot_details FROM INVESTORS AS T1 JOIN LOTS AS T2 ON  T1.investor_id  =  T2.investor_id WHERE T1.Investor_details  =  "l"
Database: tracking_share_transactions (tables: transactions, purchases)
Question: What are the purchase details of transactions with amount bigger than 10000?
SQL: SELECT T1.purchase_details FROM PURCHASES AS T1 JOIN TRANSACTIONS AS T2 ON T1.purchase_transaction_id  =  T2.transaction_id WHERE T2.amount_of_transaction  >  10000
Database: tracking_share_transactions (tables: transactions, sales)
Question: What are the sale details and dates of transactions with amount smaller than 3000?
SQL: SELECT T1.sales_details ,  T2.date_of_transaction FROM SALES AS T1 JOIN TRANSACTIONS AS T2 ON T1.sales_transaction_id  =  T2.transaction_id WHERE T2.amount_of_transaction  <  3000
Database: tracking_share_transactions (tables: lots, transactions, transactions_lots)
Question: What are the lot details of lots associated with transactions with share count smaller than 50?
SQL: SELECT T1.lot_details FROM LOTS AS T1 JOIN TRANSACTIONS_LOTS AS T2 ON T1.lot_id  =  T2.transaction_id JOIN TRANSACTIONS AS T3 ON T2.transaction_id  =  T3.transaction_id WHERE T3.share_count  <  50
Database: tracking_share_transactions (tables: lots, transactions, transactions_lots)
Question: What are the lot details of lots associated with transactions whose share count is bigger than 100 and whose type code is "PUR"?
SQL: SELECT T1.lot_details FROM LOTS AS T1 JOIN TRANSACTIONS_LOTS AS T2 ON  T1.lot_id  =  T2.transaction_id JOIN TRANSACTIONS AS T3 ON T2.transaction_id  =  T3.transaction_id WHERE T3.share_count  >  100 AND T3.transaction_type_code  =  "PUR"
Database: tracking_share_transactions (tables: transactions)
Question: Show the average transaction amount for different transaction types.
SQL: SELECT transaction_type_code ,  avg(amount_of_transaction) FROM TRANSACTIONS GROUP BY transaction_type_code
Database: tracking_share_transactions (tables: transactions)
Question: Show the maximum and minimum share count of different transaction types.
SQL: SELECT transaction_type_code ,  max(share_count) ,  min(share_count) FROM TRANSACTIONS GROUP BY transaction_type_code
Database: tracking_share_transactions (tables: transactions)
Question: Show the average share count of transactions for different investors.
SQL: SELECT investor_id ,  avg(share_count) FROM TRANSACTIONS GROUP BY investor_id
Database: tracking_share_transactions (tables: transactions)
Question: Show the average share count of transactions each each investor, ordered by average share count.
SQL: SELECT investor_id ,  avg(share_count) FROM TRANSACTIONS GROUP BY investor_id ORDER BY avg(share_count)
Database: tracking_share_transactions (tables: transactions)
Question: Show the average amount of transactions for different investors.
SQL: SELECT investor_id ,  avg(amount_of_transaction) FROM TRANSACTIONS GROUP BY investor_id
Database: tracking_share_transactions (tables: transactions, transactions_lots)
Question: Show the average amount of transactions for different lots.
SQL: SELECT T2.lot_id ,  avg(amount_of_transaction) FROM TRANSACTIONS AS T1 JOIN Transactions_Lots AS T2 ON T1.transaction_id  =  T2.transaction_id GROUP BY T2.lot_id
Database: tracking_share_transactions (tables: transactions, transactions_lots)
Question: Show the average amount of transactions for different lots, ordered by average amount of transactions.
SQL: SELECT T2.lot_id ,  avg(amount_of_transaction) FROM TRANSACTIONS AS T1 JOIN Transactions_Lots AS T2 ON T1.transaction_id  =  T2.transaction_id GROUP BY T2.lot_id ORDER BY avg(amount_of_transaction)
Database: tracking_share_transactions (tables: transactions)
Question: Show the number of transactions with transaction type code "SALE" for different investors if it is larger than 0.
SQL: SELECT investor_id ,  COUNT(*) FROM TRANSACTIONS WHERE transaction_type_code  =  "SALE" GROUP BY investor_id
Database: tracking_share_transactions (tables: transactions)
Question: Show the number of transactions for different investors.
SQL: SELECT investor_id ,  COUNT(*) FROM TRANSACTIONS GROUP BY investor_id
Database: tracking_share_transactions (tables: transactions)
Question: Show the transaction type code that occurs the fewest times.
SQL: SELECT transaction_type_code FROM TRANSACTIONS GROUP BY transaction_type_code ORDER BY COUNT(*) ASC LIMIT 1
Database: tracking_share_transactions (tables: transactions)
Question: Show the transaction type code that occurs the most frequently.
SQL: SELECT transaction_type_code FROM TRANSACTIONS GROUP BY transaction_type_code ORDER BY COUNT(*) DESC LIMIT 1
Database: tracking_share_transactions (tables: transactions, ref_transaction_types)
Question: Show the description of the transaction type that occurs most frequently.
SQL: SELECT T1.transaction_type_description FROM Ref_Transaction_Types AS T1 JOIN TRANSACTIONS AS T2 ON T1.transaction_type_code  =  T2.transaction_type_code GROUP BY T1.transaction_type_code ORDER BY COUNT(*) DESC LIMIT 1
Database: tracking_share_transactions (tables: transactions, investors)
Question: Show the id and details of the investor that has the largest number of transactions.
SQL: SELECT T2.investor_id ,  T1.Investor_details FROM INVESTORS AS T1 JOIN TRANSACTIONS AS T2 ON T1.investor_id  =  T2.investor_id GROUP BY T2.investor_id ORDER BY COUNT(*) DESC LIMIT 1
Database: tracking_share_transactions (tables: transactions, investors)
Question: Show the id and details for the investors who have the top 3 number of transactions.
SQL: SELECT T2.investor_id ,  T1.Investor_details FROM INVESTORS AS T1 JOIN TRANSACTIONS AS T2 ON T1.investor_id  =  T2.investor_id GROUP BY T2.investor_id ORDER BY COUNT(*) DESC LIMIT 3
Database: tracking_share_transactions (tables: transactions, investors)
Question: Show the ids of the investors who have at least two transactions.
SQL: SELECT T2.investor_id FROM INVESTORS AS T1 JOIN TRANSACTIONS AS T2 ON T1.investor_id  =  T2.investor_id GROUP BY T2.investor_id HAVING COUNT(*)  >=  2
Database: tracking_share_transactions (tables: transactions, investors)
Question: Show the ids and details of the investors who have at least two transactions with type code "SALE".
SQL: SELECT T2.investor_id ,  T1.Investor_details FROM INVESTORS AS T1 JOIN TRANSACTIONS AS T2 ON T1.investor_id  =  T2.investor_id WHERE T2.transaction_type_code  =  "SALE" GROUP BY T2.investor_id HAVING COUNT(*)  >=  2
Database: tracking_share_transactions (tables: transactions)
Question: What are the dates of transactions with at least 100 share count or amount bigger than 100?
SQL: SELECT date_of_transaction FROM TRANSACTIONS WHERE share_count  >=  100 OR amount_of_transaction  >=  100
Database: tracking_share_transactions (tables: purchases, sales)
Question: What are the details of all sales and purchases?
SQL: SELECT sales_details FROM sales UNION SELECT purchase_details FROM purchases
Database: tracking_share_transactions (tables: transactions_lots, lots)
Question: What are the details of the lots which are not used in any transactions?
SQL: SELECT lot_details FROM Lots EXCEPT SELECT T1.lot_details FROM Lots AS T1 JOIN transactions_lots AS T2 ON T1.lot_id  =  T2.lot_id
Database: cre_Theme_park (tables: hotels)
Question: How many available hotels are there in total?
SQL: SELECT count(*) FROM HOTELS
Database: cre_Theme_park (tables: hotels)
Question: Find the total number of available hotels.
SQL: SELECT count(*) FROM HOTELS
Database: cre_Theme_park (tables: hotels)
Question: What are the price ranges of hotels?
SQL: SELECT price_range FROM HOTELS
Database: cre_Theme_park (tables: hotels)
Question: Tell me the price ranges for all the hotels.
SQL: SELECT price_range FROM HOTELS
Database: cre_Theme_park (tables: locations)
Question: Show all distinct location names.
SQL: SELECT DISTINCT Location_Name FROM LOCATIONS
Database: cre_Theme_park (tables: locations)
Question: What are the distinct location names?
SQL: SELECT DISTINCT Location_Name FROM LOCATIONS
Database: cre_Theme_park (tables: staff)
Question: Show the names and details of all the staff members.
SQL: SELECT Name ,  Other_Details FROM Staff
Database: cre_Theme_park (tables: staff)
Question: What is the name and detail of each staff member?
SQL: SELECT Name ,  Other_Details FROM Staff
Database: cre_Theme_park (tables: visitors)
Question: Show details of all visitors.
SQL: SELECT Tourist_Details FROM VISITORS
Database: cre_Theme_park (tables: visitors)
Question: What is the detail of each visitor?
SQL: SELECT Tourist_Details FROM VISITORS
Database: cre_Theme_park (tables: hotels)
Question: Show the price ranges of hotels with 5 star ratings.
SQL: SELECT price_range FROM HOTELS WHERE star_rating_code  =  "5"
Database: cre_Theme_park (tables: hotels)
Question: What are the price ranges of five star hotels?
SQL: SELECT price_range FROM HOTELS WHERE star_rating_code  =  "5"
Database: cre_Theme_park (tables: hotels)
Question: Show the average price range of hotels that have 5 star ratings and allow pets.
SQL: SELECT avg(price_range) FROM HOTELS WHERE star_rating_code  =  "5" AND pets_allowed_yn  =  1
Database: cre_Theme_park (tables: hotels)
Question: What is the average price range of five star hotels that allow pets?
SQL: SELECT avg(price_range) FROM HOTELS WHERE star_rating_code  =  "5" AND pets_allowed_yn  =  1
Database: cre_Theme_park (tables: locations)
Question: What is the address of the location "UK Gallery"?
SQL: SELECT Address FROM LOCATIONS WHERE Location_Name  =  "UK Gallery"
Database: cre_Theme_park (tables: locations)
Question: Find the address of the location named "UK Gallery".
SQL: SELECT Address FROM LOCATIONS WHERE Location_Name  =  "UK Gallery"
Database: cre_Theme_park (tables: locations)
Question: What is the detail of the location UK Gallery?
SQL: SELECT Other_Details FROM LOCATIONS WHERE Location_Name  =  "UK Gallery"
Database: cre_Theme_park (tables: locations)
Question: Return the detail of the location named "UK Gallery".
SQL: SELECT Other_Details FROM LOCATIONS WHERE Location_Name  =  "UK Gallery"
Database: cre_Theme_park (tables: locations)
Question: Which location names contain the word "film"?
SQL: SELECT Location_Name FROM LOCATIONS WHERE Location_Name LIKE "%film%"
Database: cre_Theme_park (tables: locations)
Question: Find all the locations whose names contain the word "film".
SQL: SELECT Location_Name FROM LOCATIONS WHERE Location_Name LIKE "%film%"
Database: cre_Theme_park (tables: photos)
Question: How many distinct names are associated with all the photos?
SQL: SELECT count(DISTINCT Name) FROM PHOTOS
Database: cre_Theme_park (tables: photos)
Question: Count the number of distinct names associated with the photos.
SQL: SELECT count(DISTINCT Name) FROM PHOTOS
Database: cre_Theme_park (tables: visits)
Question: What are the distinct visit dates?
SQL: SELECT DISTINCT Visit_Date FROM VISITS
Database: cre_Theme_park (tables: visits)
Question: Find all the distinct visit dates.
SQL: SELECT DISTINCT Visit_Date FROM VISITS
Database: cre_Theme_park (tables: tourist_attractions)
Question: What are the names of the tourist attractions that can be accessed by bus?
SQL: SELECT Name FROM TOURIST_ATTRACTIONS WHERE How_to_Get_There  =  "bus"
Database: cre_Theme_park (tables: tourist_attractions)
Question: Which tourist attractions can we get to by bus? Tell me the names of the attractions.
SQL: SELECT Name FROM TOURIST_ATTRACTIONS WHERE How_to_Get_There  =  "bus"
Database: cre_Theme_park (tables: tourist_attractions)
Question: What are the names and opening hours of the tourist attractions that can be accessed by bus or walk?
SQL: SELECT Name ,  Opening_Hours FROM TOURIST_ATTRACTIONS WHERE How_to_Get_There  =  "bus" OR How_to_Get_There  =  "walk"
Database: cre_Theme_park (tables: tourist_attractions)
Question: Find the names and opening hours of the tourist attractions that we get to by bus or walk.
SQL: SELECT Name ,  Opening_Hours FROM TOURIST_ATTRACTIONS WHERE How_to_Get_There  =  "bus" OR How_to_Get_There  =  "walk"
Database: cre_Theme_park (tables: hotels, ref_hotel_star_ratings)
Question: What are the star rating descriptions of the hotels with price above 10000?
SQL: SELECT T2.star_rating_description FROM HOTELS AS T1 JOIN Ref_Hotel_Star_Ratings AS T2 ON T1.star_rating_code  =  T2.star_rating_code WHERE T1.price_range  >  10000
Database: cre_Theme_park (tables: hotels, ref_hotel_star_ratings)
Question: Give me the star rating descriptions of the hotels that cost more than 10000.
SQL: SELECT T2.star_rating_description FROM HOTELS AS T1 JOIN Ref_Hotel_Star_Ratings AS T2 ON T1.star_rating_code  =  T2.star_rating_code WHERE T1.price_range  >  10000
Database: cre_Theme_park (tables: tourist_attractions, museums)
Question: What are the details and opening hours of the museums?
SQL: SELECT T1.Museum_Details ,  T2.Opening_Hours FROM MUSEUMS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Museum_ID  =  T2.Tourist_Attraction_ID
Database: cre_Theme_park (tables: tourist_attractions, museums)
Question: Give me the detail and opening hour for each museum.
SQL: SELECT T1.Museum_Details ,  T2.Opening_Hours FROM MUSEUMS AS T1 JOIN TOURIST_ATTRACTIONS AS T2 ON T1.Museum_ID  =  T2.Tourist_Attraction_ID