target-benchmark/spider-queries huggingface dataset:
Database: county_public_safety (tables: city, county_public_safety)
Question: Show names of cities and names of counties they are in.
SQL: SELECT T1.Name ,  T2.Name FROM city AS T1 JOIN county_public_safety AS T2 ON T1.County_ID  =  T2.County_ID
Database: county_public_safety (tables: city, county_public_safety)
Question: What are the names of cities, as well as the names of the counties they correspond to?
SQL: SELECT T1.Name ,  T2.Name FROM city AS T1 JOIN county_public_safety AS T2 ON T1.County_ID  =  T2.County_ID
Database: county_public_safety (tables: city, county_public_safety)
Question: Show white percentages of cities and the crime rates of counties they are in.
SQL: SELECT T1.White ,  T2.Crime_rate FROM city AS T1 JOIN county_public_safety AS T2 ON T1.County_ID  =  T2.County_ID
Database: county_public_safety (tables: city, county_public_safety)
Question: What are the white percentages of cities, and the corresponding crime rates of the counties they correspond to?
SQL: SELECT T1.White ,  T2.Crime_rate FROM city AS T1 JOIN county_public_safety AS T2 ON T1.County_ID  =  T2.County_ID
Database: county_public_safety (tables: city, county_public_safety)
Question: Show the name of cities in the county that has the largest number of police officers.
SQL: SELECT name FROM city WHERE county_ID  =  (SELECT county_ID FROM county_public_safety ORDER BY Police_officers DESC LIMIT 1)
Database: county_public_safety (tables: city, county_public_safety)
Question: What are the names of cities that are in the county with the most police officers?
SQL: SELECT name FROM city WHERE county_ID  =  (SELECT county_ID FROM county_public_safety ORDER BY Police_officers DESC LIMIT 1)
Database: county_public_safety (tables: city, county_public_safety)
Question: Show the number of cities in counties that have a population more than 20000.
SQL: SELECT count(*) FROM city WHERE county_ID IN (SELECT county_ID FROM county_public_safety WHERE population  >  20000)
Database: county_public_safety (tables: city, county_public_safety)
Question: How many cities are in counties that have populations of over 20000?
SQL: SELECT count(*) FROM city WHERE county_ID IN (SELECT county_ID FROM county_public_safety WHERE population  >  20000)
Database: county_public_safety (tables: city, county_public_safety)
Question: Show the crime rate of counties with a city having white percentage more than 90.
SQL: SELECT T2.Crime_rate FROM city AS T1 JOIN county_public_safety AS T2 ON T1.County_ID  =  T2.County_ID WHERE T1.White  >  90
Database: county_public_safety (tables: city, county_public_safety)
Question: What are the crime rates of counties that contain cities that have white percentages of over 90?
SQL: SELECT T2.Crime_rate FROM city AS T1 JOIN county_public_safety AS T2 ON T1.County_ID  =  T2.County_ID WHERE T1.White  >  90
Database: county_public_safety (tables: county_public_safety)
Question: Please show the police forces and the number of counties with each police force.
SQL: SELECT Police_force ,  COUNT(*) FROM county_public_safety GROUP BY Police_force
Database: county_public_safety (tables: county_public_safety)
Question: How many counties correspond to each police force?
SQL: SELECT Police_force ,  COUNT(*) FROM county_public_safety GROUP BY Police_force
Database: county_public_safety (tables: county_public_safety)
Question: What is the location shared by most counties?
SQL: SELECT LOCATION FROM county_public_safety GROUP BY LOCATION ORDER BY COUNT(*) DESC LIMIT 1
Database: county_public_safety (tables: county_public_safety)
Question: Which location has the most corresponding counties?
SQL: SELECT LOCATION FROM county_public_safety GROUP BY LOCATION ORDER BY COUNT(*) DESC LIMIT 1
Database: county_public_safety (tables: city, county_public_safety)
Question: List the names of counties that do not have any cities.
SQL: SELECT Name FROM county_public_safety WHERE County_ID NOT IN (SELECT County_ID FROM city)
Database: county_public_safety (tables: city, county_public_safety)
Question: What are the names of counties that do not contain any cities?
SQL: SELECT Name FROM county_public_safety WHERE County_ID NOT IN (SELECT County_ID FROM city)
Database: county_public_safety (tables: county_public_safety)
Question: Show the police force shared by counties with location on the east and west.
SQL: SELECT Police_force FROM county_public_safety WHERE LOCATION  =  "East" INTERSECT SELECT Police_force FROM county_public_safety WHERE LOCATION  =  "West"
Database: county_public_safety (tables: county_public_safety)
Question: Which police forces operate in both counties that are located in the East and in the West?
SQL: SELECT Police_force FROM county_public_safety WHERE LOCATION  =  "East" INTERSECT SELECT Police_force FROM county_public_safety WHERE LOCATION  =  "West"
Database: county_public_safety (tables: city, county_public_safety)
Question: Show the names of cities in counties that have a crime rate less than 100.
SQL: SELECT name FROM city WHERE county_id IN (SELECT county_id FROM county_public_safety WHERE Crime_rate  <  100)
Database: county_public_safety (tables: city, county_public_safety)
Question: What are the names of cities that are in counties that have a crime rate below 100?
SQL: SELECT name FROM city WHERE county_id IN (SELECT county_id FROM county_public_safety WHERE Crime_rate  <  100)
Database: county_public_safety (tables: county_public_safety)
Question: Show the case burden of counties in descending order of population.
SQL: SELECT Case_burden FROM county_public_safety ORDER BY Population DESC
Database: county_public_safety (tables: county_public_safety)
Question: What are the case burdens of counties, ordered descending by population?
SQL: SELECT Case_burden FROM county_public_safety ORDER BY Population DESC
Database: inn_1 (tables: rooms)
Question: Find the names of all modern rooms with a base price below $160 and two beds.
SQL: SELECT roomName FROM Rooms WHERE basePrice  <  160 AND beds =  2 AND decor  =  'modern';
Database: inn_1 (tables: rooms)
Question: What are the names of modern rooms that have a base price lower than $160 and two beds.
SQL: SELECT roomName FROM Rooms WHERE basePrice  <  160 AND beds =  2 AND decor  =  'modern';
Database: inn_1 (tables: rooms)
Question: Find all the rooms that have a price higher than 160 and can accommodate more than 2 people. Report room names and ids.
SQL: SELECT roomName ,  RoomId FROM Rooms WHERE basePrice  >  160 AND maxOccupancy  >  2;
Database: inn_1 (tables: rooms)
Question: What are the room names and ids of all the rooms that cost more than 160 and can accommodate more than two people.
SQL: SELECT roomName ,  RoomId FROM Rooms WHERE basePrice  >  160 AND maxOccupancy  >  2;
Database: inn_1 (tables: reservations, rooms)
Question: Find the most popular room in the hotel. The most popular room is the room that had seen the largest number of reservations.
SQL: SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room ORDER BY count(*) DESC LIMIT 1;
Database: inn_1 (tables: reservations, rooms)
Question: Which room has the largest number of reservations?
SQL: SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room ORDER BY count(*) DESC LIMIT 1;
Database: inn_1 (tables: reservations)
Question: How many kids stay in the rooms reserved by ROY SWEAZY?
SQL: SELECT kids FROM Reservations WHERE FirstName = "ROY" AND LastName  =  "SWEAZY";
Database: inn_1 (tables: reservations)
Question: Find the number of kids staying in the rooms reserved by a person called ROY SWEAZ.
SQL: SELECT kids FROM Reservations WHERE FirstName = "ROY" AND LastName  =  "SWEAZY";
Database: inn_1 (tables: reservations)
Question: How many times does ROY SWEAZY has reserved a room.
SQL: SELECT count(*) FROM Reservations WHERE FirstName = "ROY" AND LastName  =  "SWEAZY";
Database: inn_1 (tables: reservations)
Question: Find the number of times ROY SWEAZY has reserved a room.
SQL: SELECT count(*) FROM Reservations WHERE FirstName = "ROY" AND LastName  =  "SWEAZY";
Database: inn_1 (tables: reservations, rooms)
Question: Which room has the highest rate? List the room's full name, rate, check in and check out date.
SQL: SELECT T2.roomName ,  T1.Rate ,  T1.CheckIn ,  T1.CheckOut FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room ORDER BY T1.Rate DESC LIMIT 1;
Database: inn_1 (tables: reservations, rooms)
Question: Return the name, rate, check in and check out date for the room with the highest rate.
SQL: SELECT T2.roomName ,  T1.Rate ,  T1.CheckIn ,  T1.CheckOut FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room ORDER BY T1.Rate DESC LIMIT 1;
Database: inn_1 (tables: reservations)
Question: How many adults stay in the room CONRAD SELBIG checked in on Oct 23, 2010?
SQL: SELECT Adults FROM Reservations WHERE CheckIn  =  "2010-10-23" AND FirstName  =  "CONRAD" AND LastName  =  "SELBIG";
Database: inn_1 (tables: reservations)
Question: Find the number of adults for the room reserved and checked in by CONRAD SELBIG on Oct 23, 2010.
SQL: SELECT Adults FROM Reservations WHERE CheckIn  =  "2010-10-23" AND FirstName  =  "CONRAD" AND LastName  =  "SELBIG";
Database: inn_1 (tables: reservations)
Question: How many kids stay in the room DAMIEN TRACHSEL checked in on Sep 21, 2010?
SQL: SELECT Kids FROM Reservations WHERE CheckIn  =  "2010-09-21" AND FirstName  =  "DAMIEN" AND LastName  =  "TRACHSEL";
Database: inn_1 (tables: reservations)
Question: Return the number of kids for the room reserved and checked in by DAMIEN TRACHSEL on  Sep 21, 2010.
SQL: SELECT Kids FROM Reservations WHERE CheckIn  =  "2010-09-21" AND FirstName  =  "DAMIEN" AND LastName  =  "TRACHSEL";
Database: inn_1 (tables: rooms)
Question: How many king beds are there?
SQL: SELECT sum(beds) FROM Rooms WHERE bedtype  =  'King';
Database: inn_1 (tables: rooms)
Question: Find the total number of king beds available.
SQL: SELECT sum(beds) FROM Rooms WHERE bedtype  =  'King';
Database: inn_1 (tables: rooms)
Question: List the names and decor of rooms that have a king bed. Sort the list by their price.
SQL: SELECT roomName ,  decor FROM Rooms WHERE bedtype  =  'King' ORDER BY basePrice;
Database: inn_1 (tables: rooms)
Question: What are the names and decor of rooms with a king bed? Sort them by their price
SQL: SELECT roomName ,  decor FROM Rooms WHERE bedtype  =  'King' ORDER BY basePrice;
Database: inn_1 (tables: rooms)
Question: Which room has cheapest base price? List the room's name and the base price.
SQL: SELECT roomName ,  basePrice FROM Rooms ORDER BY basePrice ASC LIMIT 1;
Database: inn_1 (tables: rooms)
Question: What are the room name and base price of the room with the lowest base price?
SQL: SELECT roomName ,  basePrice FROM Rooms ORDER BY basePrice ASC LIMIT 1;
Database: inn_1 (tables: rooms)
Question: What is the decor of room Recluse and defiance?
SQL: SELECT decor FROM Rooms WHERE roomName  =  "Recluse and defiance";
Database: inn_1 (tables: rooms)
Question: Return the decor of the room named "Recluse and defiance".
SQL: SELECT decor FROM Rooms WHERE roomName  =  "Recluse and defiance";
Database: inn_1 (tables: rooms)
Question: What is the average base price of different bed type? List bed type and average base price.
SQL: SELECT bedType ,  avg(basePrice) FROM Rooms GROUP BY bedType;
Database: inn_1 (tables: rooms)
Question: For each bed type, find the average base price of different bed type.
SQL: SELECT bedType ,  avg(basePrice) FROM Rooms GROUP BY bedType;
Database: inn_1 (tables: rooms)
Question: What is the total number of people who could stay in the modern rooms in this inn?
SQL: SELECT sum(maxOccupancy) FROM Rooms WHERE decor  =  'modern';
Database: inn_1 (tables: rooms)
Question: How many people in total can stay in the modern rooms of this inn?
SQL: SELECT sum(maxOccupancy) FROM Rooms WHERE decor  =  'modern';
Database: inn_1 (tables: reservations, rooms)
Question: What kind of decor has the least number of reservations?
SQL: SELECT T2.decor FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T2.decor ORDER BY count(T2.decor) ASC LIMIT 1;
Database: inn_1 (tables: reservations, rooms)
Question: What is the least popular kind of decor?
SQL: SELECT T2.decor FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T2.decor ORDER BY count(T2.decor) ASC LIMIT 1;
Database: inn_1 (tables: reservations, rooms)
Question: List how many times the number of people in the room reached the maximum occupancy of the room. The number of people include adults and kids.
SQL: SELECT count(*) FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId WHERE T2.maxOccupancy  =  T1.Adults + T1.Kids;
Database: inn_1 (tables: reservations, rooms)
Question: How many times the number of adults and kids staying in a room reached the maximum capacity of the room?
SQL: SELECT count(*) FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId WHERE T2.maxOccupancy  =  T1.Adults + T1.Kids;
Database: inn_1 (tables: reservations, rooms)
Question: Find the first and last names of people who payed more than the rooms' base prices.
SQL: SELECT T1.firstname ,  T1.lastname FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId WHERE T1.Rate - T2.basePrice  >  0
Database: inn_1 (tables: reservations, rooms)
Question: What are the first and last names of people who payed more than the rooms' base prices?
SQL: SELECT T1.firstname ,  T1.lastname FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId WHERE T1.Rate - T2.basePrice  >  0
Database: inn_1 (tables: rooms)
Question: How many rooms are there?
SQL: SELECT count(*) FROM Rooms;
Database: inn_1 (tables: rooms)
Question: What is the total number of rooms available in this inn?
SQL: SELECT count(*) FROM Rooms;
Database: inn_1 (tables: rooms)
Question: Find the number of rooms with a king bed.
SQL: SELECT count(*) FROM Rooms WHERE bedType  =  "King";
Database: inn_1 (tables: rooms)
Question: How many rooms have a king bed?
SQL: SELECT count(*) FROM Rooms WHERE bedType  =  "King";
Database: inn_1 (tables: rooms)
Question: Find the number of rooms for each bed type.
SQL: SELECT bedType ,  count(*) FROM Rooms GROUP BY bedType;
Database: inn_1 (tables: rooms)
Question: What are the number of rooms for each bed type?
SQL: SELECT bedType ,  count(*) FROM Rooms GROUP BY bedType;
Database: inn_1 (tables: rooms)
Question: Find the name of the room with the maximum occupancy.
SQL: SELECT roomName FROM Rooms ORDER BY maxOccupancy DESC LIMIT 1;
Database: inn_1 (tables: rooms)
Question: What is the name of the room that can accommodate the most people?
SQL: SELECT roomName FROM Rooms ORDER BY maxOccupancy DESC LIMIT 1;
Database: inn_1 (tables: rooms)
Question: Find the id and name of the most expensive base price room.
SQL: SELECT RoomId ,  roomName FROM Rooms ORDER BY basePrice DESC LIMIT 1;
Database: inn_1 (tables: rooms)
Question: Which room has the highest base price?
SQL: SELECT RoomId ,  roomName FROM Rooms ORDER BY basePrice DESC LIMIT 1;
Database: inn_1 (tables: rooms)
Question: List the type of bed and name of all traditional rooms.
SQL: SELECT roomName ,  bedType FROM Rooms WHERE decor = "traditional";
Database: inn_1 (tables: rooms)
Question: What are the bed type and name of all the rooms with traditional decor?
SQL: SELECT roomName ,  bedType FROM Rooms WHERE decor = "traditional";
Database: inn_1 (tables: rooms)
Question: Find the number of rooms with king bed for each decor type.
SQL: SELECT decor ,  count(*) FROM Rooms WHERE bedType = "King" GROUP BY decor;
Database: inn_1 (tables: rooms)
Question: How many rooms have king beds? Report the number for each decor type.
SQL: SELECT decor ,  count(*) FROM Rooms WHERE bedType = "King" GROUP BY decor;
Database: inn_1 (tables: rooms)
Question: Find the average and minimum price of the rooms in different decor.
SQL: SELECT decor , avg(basePrice) ,  min(basePrice) FROM Rooms GROUP BY decor;
Database: inn_1 (tables: rooms)
Question: What is the average minimum and price of the rooms for each different decor.
SQL: SELECT decor , avg(basePrice) ,  min(basePrice) FROM Rooms GROUP BY decor;
Database: inn_1 (tables: rooms)
Question: List the name of all rooms sorted by their prices.
SQL: SELECT roomName FROM Rooms ORDER BY basePrice;
Database: inn_1 (tables: rooms)
Question: Sort all the rooms according to the price. Just report the room names.
SQL: SELECT roomName FROM Rooms ORDER BY basePrice;
Database: inn_1 (tables: rooms)
Question: Find the number of rooms with price higher than 120 for different decor.
SQL: SELECT decor , count(*) FROM Rooms WHERE basePrice  >  120 GROUP BY decor;
Database: inn_1 (tables: rooms)
Question: How many rooms cost more than 120, for each different decor?
SQL: SELECT decor , count(*) FROM Rooms WHERE basePrice  >  120 GROUP BY decor;
Database: inn_1 (tables: rooms)
Question: For each bed type, find the average room price.
SQL: SELECT bedType ,  avg(basePrice) FROM Rooms GROUP BY bedType;
Database: inn_1 (tables: rooms)
Question: What is the average base price of rooms, for each bed type?
SQL: SELECT bedType ,  avg(basePrice) FROM Rooms GROUP BY bedType;
Database: inn_1 (tables: rooms)
Question: List the name of rooms with king or queen bed.
SQL: SELECT roomName FROM Rooms WHERE bedType  =  "King" OR bedType  =  "Queen";
Database: inn_1 (tables: rooms)
Question: What are the names of rooms that have either king or queen bed?
SQL: SELECT roomName FROM Rooms WHERE bedType  =  "King" OR bedType  =  "Queen";
Database: inn_1 (tables: rooms)
Question: How many different types of beds are there?
SQL: SELECT count(DISTINCT bedType) FROM Rooms;
Database: inn_1 (tables: rooms)
Question: Find the number of distinct bed types available in this inn.
SQL: SELECT count(DISTINCT bedType) FROM Rooms;
Database: inn_1 (tables: rooms)
Question: Find the name and id of the top 3 expensive rooms.
SQL: SELECT RoomId ,  roomName FROM Rooms ORDER BY basePrice DESC LIMIT 3;
Database: inn_1 (tables: rooms)
Question: What are the name and id of the three highest priced rooms?
SQL: SELECT RoomId ,  roomName FROM Rooms ORDER BY basePrice DESC LIMIT 3;
Database: inn_1 (tables: rooms)
Question: Find the name of rooms whose price is higher than the average price.
SQL: SELECT roomName FROM Rooms WHERE basePrice  >  ( SELECT avg(basePrice) FROM Rooms );
Database: inn_1 (tables: rooms)
Question: What are the name of rooms that cost more than the average.
SQL: SELECT roomName FROM Rooms WHERE basePrice  >  ( SELECT avg(basePrice) FROM Rooms );
Database: inn_1 (tables: reservations, rooms)
Question: Find the number of rooms that do not have any reservation.
SQL: SELECT count(*) FROM rooms WHERE roomid NOT IN (SELECT DISTINCT room FROM reservations)
Database: inn_1 (tables: reservations, rooms)
Question: How many rooms have not had any reservation yet?
SQL: SELECT count(*) FROM rooms WHERE roomid NOT IN (SELECT DISTINCT room FROM reservations)
Database: inn_1 (tables: reservations, rooms)
Question: Return the name and number of reservations made for each of the rooms.
SQL: SELECT T2.roomName ,  count(*) ,  T1.Room FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room
Database: inn_1 (tables: reservations, rooms)
Question: For each room, find its name and the number of times reservations were made for it.
SQL: SELECT T2.roomName ,  count(*) ,  T1.Room FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room
Database: inn_1 (tables: reservations, rooms)
Question: Find the names of rooms that have been reserved for more than 60 times.
SQL: SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room HAVING count(*)  >  60
Database: inn_1 (tables: reservations, rooms)
Question: What are the names of rooms whose reservation frequency exceeds 60 times?
SQL: SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId GROUP BY T1.Room HAVING count(*)  >  60
Database: inn_1 (tables: rooms)
Question: Find the name of rooms whose base price is between 120 and 150.
SQL: SELECT roomname FROM rooms WHERE baseprice BETWEEN 120 AND 150
Database: inn_1 (tables: rooms)
Question: Which rooms cost between 120 and 150? Give me the room names.
SQL: SELECT roomname FROM rooms WHERE baseprice BETWEEN 120 AND 150
Database: inn_1 (tables: reservations, rooms)
Question: Find the name of rooms booked by some customers whose first name contains ROY.
SQL: SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId WHERE firstname LIKE '%ROY%'
Database: inn_1 (tables: reservations, rooms)
Question: What are the name of rooms booked by customers whose first name has "ROY" in part?
SQL: SELECT T2.roomName FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId WHERE firstname LIKE '%ROY%'
Database: local_govt_mdm (tables: cmi_cross_references, customer_master_index)
Question: what are the details of the cmi masters that have the cross reference code 'Tax'?
SQL: SELECT T1.cmi_details FROM Customer_Master_Index AS T1 JOIN CMI_Cross_References AS T2 ON T1.master_customer_id  =  T2.master_customer_id WHERE T2.source_system_code  =  'Tax'
Database: local_govt_mdm (tables: cmi_cross_references, council_tax)
Question: What is the cmi cross reference id that is related to at least one council tax entry? List the cross reference id and source system code.
SQL: SELECT T1.cmi_cross_ref_id ,  T1.source_system_code FROM CMI_Cross_References AS T1 JOIN Council_Tax AS T2 ON T1.cmi_cross_ref_id  =  T2.cmi_cross_ref_id GROUP BY T1.cmi_cross_ref_id HAVING count(*)  >=  1
Database: local_govt_mdm (tables: cmi_cross_references, business_rates)
Question: How many business rates are related to each cmi cross reference? List cross reference id, master customer id and the n
SQL: SELECT T2.cmi_cross_ref_id ,  T2.master_customer_id ,  count(*) FROM Business_Rates AS T1 JOIN CMI_Cross_References AS T2 ON T1.cmi_cross_ref_id  =  T2.cmi_cross_ref_id GROUP BY T2.cmi_cross_ref_id
Database: local_govt_mdm (tables: cmi_cross_references, benefits_overpayments)
Question: What is the tax source system code related to the benefits and overpayments? List the code and the benifit id, order by benifit id.
SQL: SELECT T1.source_system_code ,  T2.council_tax_id FROM CMI_Cross_References AS T1 JOIN Benefits_Overpayments AS T2 ON T1.cmi_cross_ref_id  =  T2.cmi_cross_ref_id ORDER BY T2.council_tax_id
Database: local_govt_mdm (tables: cmi_cross_references, parking_fines)
Question: Wat is the tax source system code and master customer id of the taxes related to each parking fine id?
SQL: SELECT T1.source_system_code ,  T1.master_customer_id ,  T2.council_tax_id FROM CMI_Cross_References AS T1 JOIN Parking_Fines AS T2 ON T1.cmi_cross_ref_id  =  T2.cmi_cross_ref_id
Database: local_govt_mdm (tables: cmi_cross_references, rent_arrears, customer_master_index)
Question: What are the renting arrears tax ids related to the customer master index whose detail is not 'Schmidt, Kertzmann and Lubowitz'?
SQL: SELECT T1.council_tax_id FROM Rent_Arrears AS T1 JOIN CMI_Cross_References AS T2 ON T1.cmi_cross_ref_id  =  T2.cmi_cross_ref_id JOIN Customer_Master_Index AS T3 ON T3.master_customer_id  =  T2.master_customer_id WHERE T3.cmi_details != 'Schmidt ,  Kertzmann and Lubowitz'
Database: local_govt_mdm (tables: cmi_cross_references, electoral_register)
Question: What are the register ids of electoral registries that have the cross reference source system code 'Electoral' or 'Tax'?
SQL: SELECT T1.electoral_register_id FROM Electoral_Register AS T1 JOIN CMI_Cross_References AS T2 ON T1.cmi_cross_ref_id  =  T2.cmi_cross_ref_id WHERE T2.source_system_code  =  'Electoral' OR T2.source_system_code  =  'Tax'
Database: local_govt_mdm (tables: cmi_cross_references)
Question: How many different source system code for the cmi cross references are there?
SQL: SELECT count(DISTINCT source_system_code) FROM CMI_cross_references
Database: local_govt_mdm (tables: customer_master_index)
Question: List all information about customer master index, and sort them by details in descending order.
SQL: SELECT * FROM customer_master_index ORDER BY cmi_details DESC