target-benchmark/spider-queries huggingface dataset:
Database: cre_Students_Information_Systems (tables: student_events, students)
Question: Find the biographical data and event date for students who participated in any events.
SQL: SELECT T1.bio_data ,  T2.event_date FROM Students AS T1 JOIN Student_Events AS T2 ON T1.student_id  =  T2.student_id
Database: cre_Students_Information_Systems (tables: ref_event_types, student_events, students)
Question: How many students have joined in the most common type of event? List the number, the event type and description.
SQL: SELECT count(*) ,  T2.event_type_code ,  T3.event_type_description FROM Students AS T1 JOIN Student_Events AS T2 ON T1.student_id  =  T2.student_id JOIN Ref_Event_Types AS T3 ON T2.event_type_code  =  T3.event_type_code GROUP BY T2.event_type_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: ref_event_types, student_events, students)
Question: What is the type of event the most students joined? Give me the number of students, and the event type code and description.
SQL: SELECT count(*) ,  T2.event_type_code ,  T3.event_type_description FROM Students AS T1 JOIN Student_Events AS T2 ON T1.student_id  =  T2.student_id JOIN Ref_Event_Types AS T3 ON T2.event_type_code  =  T3.event_type_code GROUP BY T2.event_type_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: ref_achievement_type, achievements)
Question: How are all the achievements described? List the achievement detail and the type description.
SQL: SELECT T1.achievement_details ,  T2.achievement_type_description FROM Achievements AS T1 JOIN Ref_Achievement_Type AS T2 ON T1.achievement_type_code  =  T2.achievement_type_code
Database: cre_Students_Information_Systems (tables: ref_achievement_type, achievements)
Question: What are the achievement detail and the type description of each achievements?
SQL: SELECT T1.achievement_details ,  T2.achievement_type_description FROM Achievements AS T1 JOIN Ref_Achievement_Type AS T2 ON T1.achievement_type_code  =  T2.achievement_type_code
Database: cre_Students_Information_Systems (tables: achievements, teachers, classes)
Question: How many teachers have taught a student who has not won any achievements?
SQL: SELECT count(DISTINCT T1.teacher_id) FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id WHERE T2.student_id NOT IN ( SELECT student_id FROM Achievements )
Database: cre_Students_Information_Systems (tables: achievements, teachers, classes)
Question: Count the number of teachers who have taught students who have never won an achievement.
SQL: SELECT count(DISTINCT T1.teacher_id) FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id WHERE T2.student_id NOT IN ( SELECT student_id FROM Achievements )
Database: cre_Students_Information_Systems (tables: transcripts)
Question: List the date of the transcripts and the transcript details.
SQL: SELECT date_of_transcript ,  transcript_details FROM Transcripts
Database: cre_Students_Information_Systems (tables: transcripts)
Question: What are the date and detail of each transcript?
SQL: SELECT date_of_transcript ,  transcript_details FROM Transcripts
Database: cre_Students_Information_Systems (tables: achievements)
Question: List the achievement type code, achievement details and the date of the achievements.
SQL: SELECT achievement_type_code ,  achievement_details ,  date_achievement FROM Achievements
Database: cre_Students_Information_Systems (tables: achievements)
Question: What are the type code, details, and date of each achievement?
SQL: SELECT achievement_type_code ,  achievement_details ,  date_achievement FROM Achievements
Database: cre_Students_Information_Systems (tables: detention)
Question: Show the detention start time and end time of the detentions.
SQL: SELECT datetime_detention_start ,  datetime_detention_end FROM Detention
Database: cre_Students_Information_Systems (tables: detention)
Question: What are the starting time and ending time of each detention record?
SQL: SELECT datetime_detention_start ,  datetime_detention_end FROM Detention
Database: cre_Students_Information_Systems (tables: students)
Question: Show the biographical information of the students whose details include the substring 'Suite'.
SQL: SELECT bio_data FROM Students WHERE student_details LIKE '%Suite%'
Database: cre_Students_Information_Systems (tables: students)
Question: Which students have 'Suite' as a substring in their details? Give me their biographical information.
SQL: SELECT bio_data FROM Students WHERE student_details LIKE '%Suite%'
Database: cre_Students_Information_Systems (tables: teachers, classes, students)
Question: List the details for all the pairs of teachers and students who are in the same class.
SQL: SELECT T1.teacher_details ,  T3.student_details FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id JOIN Students AS T3 ON T2.student_id  =  T3.student_id
Database: cre_Students_Information_Systems (tables: teachers, classes, students)
Question: What are the pairs of teachers and students who are in the same class? Give me the pairs of their details.
SQL: SELECT T1.teacher_details ,  T3.student_details FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id JOIN Students AS T3 ON T2.student_id  =  T3.student_id
Database: cre_Students_Information_Systems (tables: classes)
Question: How many courses do teachers teach at most? Also find the id of the teacher who teaches the most.
SQL: SELECT count(*) ,  teacher_id FROM Classes GROUP BY teacher_id ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: classes)
Question: Which teacher teaches the most courses? Give me the id of the teacher and the number of courses he or she teaches.
SQL: SELECT count(*) ,  teacher_id FROM Classes GROUP BY teacher_id ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: classes)
Question: How many courses do students take at most? Also find the id of the student who takes the most courses.
SQL: SELECT count(*) ,  student_id FROM Classes GROUP BY student_id ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: classes)
Question: Which student is taking the most courses? Give me the id of the student and the number of courses he or she is taking.
SQL: SELECT count(*) ,  student_id FROM Classes GROUP BY student_id ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: classes, students)
Question: Which students take 2 courses? List student id and details.
SQL: SELECT T1.student_id ,  T1.student_details FROM Students AS T1 JOIN Classes AS T2 ON T1.student_id  =  T2.student_id GROUP BY T1.student_id HAVING count(*)  =  2
Database: cre_Students_Information_Systems (tables: classes, students)
Question: What are the ids and details of the students who take 2 courses?
SQL: SELECT T1.student_id ,  T1.student_details FROM Students AS T1 JOIN Classes AS T2 ON T1.student_id  =  T2.student_id GROUP BY T1.student_id HAVING count(*)  =  2
Database: cre_Students_Information_Systems (tables: ref_detention_type, detention)
Question: What is the least common detention type? Show the type code and the description.
SQL: SELECT T1.detention_type_code ,  T2.detention_type_description FROM Detention AS T1 JOIN Ref_Detention_Type AS T2 ON T1.detention_type_code  =  T2.detention_type_code GROUP BY T1.detention_type_code ORDER BY count(*) ASC LIMIT 1
Database: cre_Students_Information_Systems (tables: ref_detention_type, detention)
Question: Give me the type code and description of the least common detention type.
SQL: SELECT T1.detention_type_code ,  T2.detention_type_description FROM Detention AS T1 JOIN Ref_Detention_Type AS T2 ON T1.detention_type_code  =  T2.detention_type_code GROUP BY T1.detention_type_code ORDER BY count(*) ASC LIMIT 1
Database: cre_Students_Information_Systems (tables: student_loans, students)
Question: Which students have a student loan more than the average amount? List the students' biographical data and the details.
SQL: SELECT T1.bio_data ,  T1.student_details FROM Students AS T1 JOIN Student_Loans AS T2 ON T1.student_id  =  T2.student_id WHERE T2.amount_of_loan  >  ( SELECT avg(amount_of_loan) FROM Student_Loans )
Database: cre_Students_Information_Systems (tables: student_loans, students)
Question: Find the biographical data and details for students whose student loan is above the average amount.
SQL: SELECT T1.bio_data ,  T1.student_details FROM Students AS T1 JOIN Student_Loans AS T2 ON T1.student_id  =  T2.student_id WHERE T2.amount_of_loan  >  ( SELECT avg(amount_of_loan) FROM Student_Loans )
Database: cre_Students_Information_Systems (tables: student_loans)
Question: When was the earliest date of loan?
SQL: SELECT date_of_loan FROM Student_Loans ORDER BY date_of_loan ASC LIMIT 1
Database: cre_Students_Information_Systems (tables: student_loans)
Question: Return the earliest date of loan in the record.
SQL: SELECT date_of_loan FROM Student_Loans ORDER BY date_of_loan ASC LIMIT 1
Database: cre_Students_Information_Systems (tables: student_loans, students)
Question: Which student has the loan with the minimum value? List the student's biographical information.
SQL: SELECT T1.bio_data FROM Students AS T1 JOIN Student_Loans AS T2 ON T1.student_id  =  T2.student_id ORDER BY T2.amount_of_loan ASC LIMIT 1
Database: cre_Students_Information_Systems (tables: student_loans, students)
Question: Find the biographical information of the student with the smallest student loan.
SQL: SELECT T1.bio_data FROM Students AS T1 JOIN Student_Loans AS T2 ON T1.student_id  =  T2.student_id ORDER BY T2.amount_of_loan ASC LIMIT 1
Database: cre_Students_Information_Systems (tables: transcripts, student_loans)
Question: When was the transcript issued for the student with loan of maximum value?
SQL: SELECT T1.date_of_transcript FROM Transcripts AS T1 JOIN Student_Loans AS T2 ON T1.student_id  =  T2.student_id ORDER BY T2.amount_of_loan DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: transcripts, student_loans)
Question: What is the transcript issuance date for the student with the largest amount of loan?
SQL: SELECT T1.date_of_transcript FROM Transcripts AS T1 JOIN Student_Loans AS T2 ON T1.student_id  =  T2.student_id ORDER BY T2.amount_of_loan DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: transcripts, teachers, classes)
Question: Which teachers have taught the student with the earliest transcript issuance? List the teacher details.
SQL: SELECT T1.teacher_details FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id JOIN Transcripts AS T3 ON T2.student_id  =  T3.student_id ORDER BY T3.date_of_transcript ASC LIMIT 1
Database: cre_Students_Information_Systems (tables: transcripts, teachers, classes)
Question: Find the details of the teachers who have taught the student with the earliest transcript issuance.
SQL: SELECT T1.teacher_details FROM Teachers AS T1 JOIN Classes AS T2 ON T1.teacher_id  =  T2.teacher_id JOIN Transcripts AS T3 ON T2.student_id  =  T3.student_id ORDER BY T3.date_of_transcript ASC LIMIT 1
Database: cre_Students_Information_Systems (tables: student_loans)
Question: How much total loan does each student have ? List the student ids and the amounts .
SQL: select student_id ,  sum(amount_of_loan) from student_loans group by student_id
Database: cre_Students_Information_Systems (tables: student_loans)
Question: For each student, find the student id and the total amount of loan he or she has.
SQL: SELECT student_id ,  sum(amount_of_loan) FROM Student_Loans GROUP BY student_id
Database: cre_Students_Information_Systems (tables: classes, students)
Question: How many courses does each student take? List the student id, the student biographical data and the course count.
SQL: SELECT T1.student_id ,  T1.bio_data ,  count(*) FROM Students AS T1 JOIN Classes AS T2 ON T1.student_id  =  T2.student_id GROUP BY T1.student_id
Database: cre_Students_Information_Systems (tables: classes, students)
Question: For each student, find the student id, student biographical data, and the number of courses he or she takes.
SQL: SELECT T1.student_id ,  T1.bio_data ,  count(*) FROM Students AS T1 JOIN Classes AS T2 ON T1.student_id  =  T2.student_id GROUP BY T1.student_id
Database: cre_Students_Information_Systems (tables: detention)
Question: How many students have gone through a detention?
SQL: SELECT count(DISTINCT student_id) FROM Detention
Database: cre_Students_Information_Systems (tables: detention)
Question: Count the number of students who have a detention record.
SQL: SELECT count(DISTINCT student_id) FROM Detention
Database: cre_Students_Information_Systems (tables: ref_address_types, students_addresses)
Question: What is the code and description of the most common student address type?
SQL: SELECT T1.address_type_code ,  T2.address_type_description FROM Students_Addresses AS T1 JOIN Ref_Address_Types AS T2 WHERE T1.address_type_code  =  T2.address_type_code GROUP BY T1.address_type_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: ref_address_types, students_addresses)
Question: What is the most common student address type? Give me the code and description of the address type.
SQL: SELECT T1.address_type_code ,  T2.address_type_description FROM Students_Addresses AS T1 JOIN Ref_Address_Types AS T2 WHERE T1.address_type_code  =  T2.address_type_code GROUP BY T1.address_type_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Students_Information_Systems (tables: student_loans, student_events, students)
Question: For those students who have gone through an event, who do not have a student loan? List the students' biographical data
SQL: SELECT T1.bio_data FROM Students AS T1 JOIN Student_Events AS T2 WHERE T1.student_id  =  T2.student_id EXCEPT SELECT T1.bio_data FROM Students AS T1 JOIN Student_Loans AS T2 WHERE T1.student_id  =  T2.student_id
Database: cre_Students_Information_Systems (tables: student_loans, student_events, students)
Question: Among the students who have an event record, who do not have a student loan? Return the students' biographical data.
SQL: SELECT T1.bio_data FROM Students AS T1 JOIN Student_Events AS T2 WHERE T1.student_id  =  T2.student_id EXCEPT SELECT T1.bio_data FROM Students AS T1 JOIN Student_Loans AS T2 WHERE T1.student_id  =  T2.student_id
Database: cre_Students_Information_Systems (tables: transcripts, students_addresses)
Question: List the start time and the end time of the students' addresses for the students who have 2 transcripts.
SQL: SELECT date_from ,  date_to FROM Students_Addresses WHERE student_id IN ( SELECT student_id FROM Transcripts GROUP BY student_id HAVING count(*)  =  2 )
Database: cre_Students_Information_Systems (tables: transcripts, students_addresses)
Question: What are the start time and end time of addresses for the students who receive 2 transcripts?
SQL: SELECT date_from ,  date_to FROM Students_Addresses WHERE student_id IN ( SELECT student_id FROM Transcripts GROUP BY student_id HAVING count(*)  =  2 )
Database: cre_Students_Information_Systems (tables: detention)
Question: When did all the detentions start?
SQL: SELECT datetime_detention_start FROM Detention
Database: cre_Students_Information_Systems (tables: detention)
Question: Give me the detention start date for all the detention records.
SQL: SELECT datetime_detention_start FROM Detention
Database: book_1 (tables: author)
Question: List all the author names.
SQL: SELECT name FROM Author
Database: book_1 (tables: author)
Question: What are the names of all the authors?
SQL: SELECT name FROM Author
Database: book_1 (tables: client)
Question: Show all Client names and their addresses.
SQL: SELECT name ,  address FROM Client
Database: book_1 (tables: client)
Question: What are the names and addressed of all clients?
SQL: SELECT name ,  address FROM Client
Database: book_1 (tables: book)
Question: List all Book titles, ISBNs, and sale prices.
SQL: SELECT title ,  isbn ,  SalePrice FROM Book
Database: book_1 (tables: book)
Question: What are the titles, ISBNs, and sale prices for all books?
SQL: SELECT title ,  isbn ,  SalePrice FROM Book
Database: book_1 (tables: book)
Question: How many books do we have?
SQL: SELECT count(*) FROM Book
Database: book_1 (tables: book)
Question: Count the number of books.
SQL: SELECT count(*) FROM Book
Database: book_1 (tables: author)
Question: How many authors are there?
SQL: SELECT count(*) FROM Author
Database: book_1 (tables: author)
Question: Count the number of authors.
SQL: SELECT count(*) FROM Author
Database: book_1 (tables: client)
Question: How many clients are there?
SQL: SELECT count(*) FROM Client
Database: book_1 (tables: client)
Question: Return the number of clients.
SQL: SELECT count(*) FROM Client
Database: book_1 (tables: client)
Question: List names and addresses of all clients in alphabetical order by their names.
SQL: SELECT name ,  address FROM Client ORDER BY name
Database: book_1 (tables: client)
Question: What are the names and addressed of all clients, ordered alphabetically by name?
SQL: SELECT name ,  address FROM Client ORDER BY name
Database: book_1 (tables: author_book, author, book)
Question: Show all book titles and corresponding author names.
SQL: SELECT T3.title ,  T1.name FROM Author AS T1 JOIN Author_Book AS T2 ON T2.Author  =  T1.idAuthor JOIN Book AS T3 ON T2.isbn  =  T3.isbn
Database: book_1 (tables: author_book, author, book)
Question: What are the names of all books and their corresponding authors?
SQL: SELECT T3.title ,  T1.name FROM Author AS T1 JOIN Author_Book AS T2 ON T2.Author  =  T1.idAuthor JOIN Book AS T3 ON T2.isbn  =  T3.isbn
Database: book_1 (tables: orders, client)
Question: Show all order ids and their client names.
SQL: SELECT T1.idOrder ,  T2.name FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient
Database: book_1 (tables: orders, client)
Question: What are the ids of all orders and the corresponding client names?
SQL: SELECT T1.idOrder ,  T2.name FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient
Database: book_1 (tables: author_book, author)
Question: Show all author names and the numbers of books each has written.
SQL: SELECT T1.name ,  count(*) FROM Author AS T1 JOIN Author_Book AS T2 ON T1.idAuthor  =  T2.Author GROUP BY T1.idAuthor
Database: book_1 (tables: author_book, author)
Question: What are the names of all the authors, and how many books has each written?
SQL: SELECT T1.name ,  count(*) FROM Author AS T1 JOIN Author_Book AS T2 ON T1.idAuthor  =  T2.Author GROUP BY T1.idAuthor
Database: book_1 (tables: books_order)
Question: Show all book isbns and the numbers of orders for each.
SQL: SELECT isbn ,  count(*) FROM Books_Order GROUP BY isbn
Database: book_1 (tables: books_order)
Question: What are all isbns for each book, and how many times has each been ordered?
SQL: SELECT isbn ,  count(*) FROM Books_Order GROUP BY isbn
Database: book_1 (tables: books_order)
Question: Show all book isbns and the total amount ordered for each.
SQL: SELECT isbn ,  sum(amount) FROM Books_Order GROUP BY isbn
Database: book_1 (tables: books_order)
Question: What are the isbns for all books, and what is the total amount ordered for each?
SQL: SELECT isbn ,  sum(amount) FROM Books_Order GROUP BY isbn
Database: book_1 (tables: book, books_order)
Question: Show the book title corresponding to the book with the most number of orders.
SQL: SELECT T2.title FROM Books_Order AS T1 JOIN Book AS T2 ON T1.isbn  =  T2.isbn GROUP BY T1.isbn ORDER BY count(*) DESC LIMIT 1
Database: book_1 (tables: book, books_order)
Question: What is the title of the book that has been ordered the greatest number of times?
SQL: SELECT T2.title FROM Books_Order AS T1 JOIN Book AS T2 ON T1.isbn  =  T2.isbn GROUP BY T1.isbn ORDER BY count(*) DESC LIMIT 1
Database: book_1 (tables: book, books_order)
Question: Show the book title and purchase price of the book that has had the greatest amount in orders.
SQL: SELECT T2.title ,  T2.PurchasePrice FROM Books_Order AS T1 JOIN BOOk AS T2 ON T1.isbn  =  T2.isbn GROUP BY T1.isbn ORDER BY sum(amount) DESC LIMIT 1
Database: book_1 (tables: book, books_order)
Question: What is the title and purchase price of the book that has the highest total order amount?
SQL: SELECT T2.title ,  T2.PurchasePrice FROM Books_Order AS T1 JOIN BOOk AS T2 ON T1.isbn  =  T2.isbn GROUP BY T1.isbn ORDER BY sum(amount) DESC LIMIT 1
Database: book_1 (tables: books_order, book)
Question: Show the titles of books that have been ordered.
SQL: SELECT DISTINCT T1.title FROM book AS T1 JOIN books_order AS T2 ON T1.isbn  =  T2.isbn
Database: book_1 (tables: books_order, book)
Question: What are the different titles of books that have been ordered in the past?
SQL: SELECT DISTINCT T1.title FROM book AS T1 JOIN books_order AS T2 ON T1.isbn  =  T2.isbn
Database: book_1 (tables: orders, client)
Question: Show the names of clients who have ordered at least once.
SQL: SELECT DISTINCT T1.name FROM Client AS T1 JOIN Orders AS T2 ON T1.idClient  =  T2.idClient
Database: book_1 (tables: orders, client)
Question: What are the names of the different clients who have made an order?
SQL: SELECT DISTINCT T1.name FROM Client AS T1 JOIN Orders AS T2 ON T1.idClient  =  T2.idClient
Database: book_1 (tables: orders, client)
Question: Show all client names and the number of orders each has made.
SQL: SELECT T2.name ,  count(*) FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient GROUP BY T1.idClient
Database: book_1 (tables: orders, client)
Question: What are the names of all the clients, and how many times has each of them ordered?
SQL: SELECT T2.name ,  count(*) FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient GROUP BY T1.idClient
Database: book_1 (tables: orders, client)
Question: What is the name of the client with the most number of orders?
SQL: SELECT T2.name FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient GROUP BY T1.idClient ORDER BY count(*) DESC LIMIT 1
Database: book_1 (tables: orders, client)
Question: Give the name of the client who has made the most orders.
SQL: SELECT T2.name FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient GROUP BY T1.idClient ORDER BY count(*) DESC LIMIT 1
Database: book_1 (tables: orders, client, books_order)
Question: Show the client names and their total amounts of books ordered.
SQL: SELECT T2.name ,  sum(T3.amount) FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient JOIN Books_Order AS T3 ON T3.idOrder  =  T1.idOrder GROUP BY T1.idClient
Database: book_1 (tables: orders, client, books_order)
Question: What are the names of all the clients, and the total amount of books ordered by each?
SQL: SELECT T2.name ,  sum(T3.amount) FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient JOIN Books_Order AS T3 ON T3.idOrder  =  T1.idOrder GROUP BY T1.idClient
Database: book_1 (tables: orders, client, books_order)
Question: Show the client name who has the most total amount of books ordered.
SQL: SELECT T2.name FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient JOIN Books_Order AS T3 ON T3.idOrder  =  T1.idOrder GROUP BY T1.idClient ORDER BY sum(T3.amount) DESC LIMIT 1
Database: book_1 (tables: orders, client, books_order)
Question: What is the name of the client who has ordered the greatest total amount of books?
SQL: SELECT T2.name FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient JOIN Books_Order AS T3 ON T3.idOrder  =  T1.idOrder GROUP BY T1.idClient ORDER BY sum(T3.amount) DESC LIMIT 1
Database: book_1 (tables: books_order, book)
Question: Show all book titles for books that have no orders.
SQL: SELECT title FROM book EXCEPT SELECT T1.title FROM book AS T1 JOIN books_order AS T2 ON T1.isbn  =  T2.isbn
Database: book_1 (tables: books_order, book)
Question: What are the titles of books that have never been ordered?
SQL: SELECT title FROM book EXCEPT SELECT T1.title FROM book AS T1 JOIN books_order AS T2 ON T1.isbn  =  T2.isbn
Database: book_1 (tables: orders, client)
Question: Show all client names for clients who have not made orders.
SQL: SELECT name FROM Client EXCEPT SELECT T1.name FROM Client AS T1 JOIN Orders AS T2 ON T1.idClient  =  T2.idClient