Query normalised data

1. Query all books sorted by language_id and title:

   def select_all_records_ordered_by_language_number(cursor):
       print("All books ordered by language id and title:")
       for row in cursor.execute(
           """SELECT language_code, author, title FROM books
                                    ORDER BY language_code,title"""
       ):
           print(row)
   

   All books ordered by language id and title:
   (1, 'Veit Schiele', 'Jupyter Tutorial')
   (2, 'Veit Schiele', 'Jupyter Tutorial')
   (2, 'Veit Schiele', 'PyViz Tutorial')
   (2, 'Veit Schiele', 'Python basics')
   

2. In order to receive not only the ID of the languages but also the corresponding language codes, a connection to the language codes stored there is established with JOIN via the id column in the languages table:

   def select_all_records_ordered_by_language_code(cursor):
       print("All books ordered by language code and title:")
       for row in cursor.execute(
           """SELECT languages.language_code, books.author, books.title
                                    FROM books
                                    JOIN languages ON (books.language_code = languages.id)
                                    ORDER BY languages.language_code,title"""
       ):
           print(row)
   

   All books ordered by language code and title:
   ('de', 'Veit Schiele', 'Jupyter Tutorial')
   ('en', 'Veit Schiele', 'Jupyter Tutorial')
   ('en', 'Veit Schiele', 'PyViz Tutorial')
   ('en', 'Veit Schiele', 'Python basics')