Question: 1. Create a database called sample. 2. Create a table called test_data and load the following data into the table. Note: the following pictures were

1. Create a database called "sample". 2. Create a
1. Create a database called "sample". 2. Create a table called "test_data" and load the following data into the table. Note: the following pictures were took from SQL workbench. dass age menopause tumor_size node_caps deg_malig breast breast_quad irradiat No 35 premeno 31 no left left_low no No 42 premeno 22 N right right_up no No 30 premeno 23 no left left_low no No 61 ge 40 16 no right left_up no No 45 premeno 2 no right right_low no NN No 64 ge 40 17 left left_Jow no No 52 premeno 27 left left_low no No 67 ge 40 21 left left_Jow no Yes 41 premeno 52 left left_low no Yes 43 premeno 22 right left_up no Yes 41 premeno 1 left central Yes 44 ge 40 27 left left_Jow Yes 61 It40 14 left right_up Yes 55 ge40 26 left right_up Yes 44 premeno 32 left left_up 3. Write SQL queries to select/compute data from the "test_data" table. a. Select all rows where menopause column has the value "ge40 ". class age menopause tumor_size node_caps deg_malig breast breast_quad irradiat No 61 ge 40 16 no right left_up no No 64 ge40 17 no N left left_Jow no No 67 ge 40 21 no left left_low no Yes 44 ge 40 27 no 2 left left_Jow no 26 W Yes 55 ge 40 left right_up no b. Select all rows where age is less than 41. class age menopause tumor_size node_caps deg_malig breast breast_quad irradiat No 35 premeno 31 no left left_Jow no NW No 30 premeno 23 no left left_low no c. Select all rows where age is less than 41 and menopause column has the value "ge40 "

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!