Question 1:

Write Python program that connects to a sqlite database.

Create table called Horses with the following fields:

• id (integer): a primary key and not null
• name (text)
• breed (text)
• height (real)
• birthday (text)

Next, insert the following data row into the Horses table:

id: 1 name: 'Babe' breed: 'Quarter Horse' height: 15.3 birthday: '2015-02-10' 

Output all records from the Horses table.

Ex: With the above row inserted, the output should be:

All Horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10') 

Question 2:

I am new to coding and have been doing some online questions to improve but am stuck on this question if anybody could help.

A program that generates a text-based histogram for a list of labels/values read from standard input. The histogram should show percentages of the total input values - if there were 3 input with values 10, 5 and 5, 10 would show 50% on the histogram, 5 would show 25%. For the above listing, the following histogram would print:

Standard Input = How much wood would a woodchuck chuck if a woodchuck could chuck wood.

WOODCHUCK [***] 15%

WOOD [***] 15%

CHUCK [***] 15%

A [***] 15%

WOULD [**] 7%

MUCH [**] 7%

IF [**] 7%

HOW [**] 7%

COULD [**] 7%