Write a sqlite3 program that creates a database test.db with a table horse_table with columns horse...

Transcribed Image Text:

Write a sqlite3 program that creates a database test.db with a table horse_table with columns horse (text, the name of a horse) and age (int, the age of the horse). On the file data, txt, whose contents are the following (famous horses and my fictional ages for them). 12 Cincinnati Seabiscuit 6 Bucephalus 14 Secretariat 7 Trigger 10 Marengo 13 Joey 8 Read in the lines and create a row in horse_table for each line. Use a prepared statement. Write another sqlite3 program, this time to find all the horses in hor se_table whose ages are greater than 7 and less then 13. Print out their names, giving Cincinnati Trigger Joey Again use a prepared statement. Write a sqlite3 program that creates a database test.db with a table horse_table with columns horse (text, the name of a horse) and age (int, the age of the horse). On the file data, txt, whose contents are the following (famous horses and my fictional ages for them). 12 Cincinnati Seabiscuit 6 Bucephalus 14 Secretariat 7 Trigger 10 Marengo 13 Joey 8 Read in the lines and create a row in horse_table for each line. Use a prepared statement. Write another sqlite3 program, this time to find all the horses in hor se_table whose ages are greater than 7 and less then 13. Print out their names, giving Cincinnati Trigger Joey Again use a prepared statement.

Answer rating: 100% (QA)

Here is the sqlite3 program to create the database testdb table horsetable and insert ... View the full answer