1 points Save Ariswer QUESTION 1 Consider the following SQL table, called LDL Cholet, of LDL Cholesterol Levels ancl their classifications. NB: Although the classifications in the table are generally accepted, a fictitious maximum has been added to the vory High Rick category for the purpose of this exercise.) Classification Desirable Optimal Bordezline High liga Riek Very High isk Min 40 100 130 160 190 Max 129 159 183 250 Assume that fields Min and Max are both numeric and ciaificatien is a character string. Create an SOL query so that it produces the following output: Class1fication Borderlinc High Optimal SELECT FROM Min, Max Classification Borderline High Max -100 AND Max159 Max >-100 OR Max -159 Max >100 AND Max -100 AND -159 Consider a Python GUI program that produces a window with the following widgets: a label to display a photo image: two buttons that are used to flip the image in different ways: one vertically and the other horizontally. The initial output from this program is shown below: 74 Flip Image Flip vertically flip horizontally Hitting the "Flip vertically" button once (from the initial state above) produces the follow ing output: Flip Image Flip vertically Flip horizontally Hitting the "Flip horizontally" button once (from the initial state above) produces the following output Flip Image Hitting the "Flip horizontally" button once (from the initial state above) produces the following output 74 Flip Image Flip vertically Flip horizontally Most of the back-end of the program has already been written. Amongst other things, the following variable has been created: window-Tk The following functions have also been complete: ve rtical-flip() # flips the image in the label vertically horizontal-flip() # flips the image in the label horizontally YOUR TASK is to construct the two buttons for the GUI by completing the code below. # create the buttons buttonVertical text = "Flip vertically", text "Flip horizontally", Text Label window button command vertical_flip command horizontal _flip Window Image vertical_flip0 horizontal_flip) Button command- vertical_flip) command-horizontal-flip() QUESTION 3 Consider the following SOL table, called LDL_Cholesterol, of LDL Cholesterol Levels and their classifications. (NB: Although the classifications in the table are generally accepted, a fictitious maximum has been added to the Very High Risk category for the purpose of this exercise.) Classification Desirable Optimal Borderline High High Risk Very High Risk Mn 40 100 130 160 190 Max 129 159 189 250 Assume that fields Min and Max are both numeric and classification is a character string. Now assume that you want to add a new row to the table to classify any level below 40 as 'Unusually Low'. Complete the following SQL statement so that it will add such a row to the table INSERT INTO VALUES LDL_Cholesterol Classification Min QUESTION 4Max (Unusually Low, 0, 39) Consider a Pyth following formation Min, Max Min >= 0 AND Max 250 190> Min QUT Home Hiq Digital Workplace