For all problems write the code and run it in MySQL. Show me the statement and the output.

Problem #1:Write the statement to create a table with at least two numeric fields and two string/text problems.

Problem #2: Write the statement to populate the table - enter data so you can successfully do the queries below.

Problem #3: Write the select statement to test for condA and condB or condC and condD.

Problem #4: Write the select statement to test for condA and either condB or condC.

Problem #5: Write the select statement to sort on a field.

Problem #6: Write the statement to make a change to one of the fields on your table.

Problem #7: Write the select statement to select a field in a range using the between clause.

Problem #8: Write the select statement to match one of your fields to a list using in.

Problem #9: Write the statement to delete one of your records.

Problem #10: Write the statement to use a group function to get a sum and a count.