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.