The System supports fuzzy search for properties. Write one (1) SQL statement that lists all properties whose street name (part of its address) starts with character 'M'. Your query should return a table in the following format. Property ID, Street Address, Suburb, State, Status, List price.

Write another one (1) MySQL statement that lists all properties whose street name (part of its address) contains 'bay'. Your query should return a table in the following format. Property ID, Street Address, Suburb, State, status, List price.

Transcribed Image Text:

Task 10. (2+2 = 4 marks) The System supports fuzzy search for properties. Write one (1) SQL statement that lists all properties whose street name (part of its address) starts with character 'M'. Your query should return a table in the following format. Property ID Street Address Suburb State Status State Write another one (1) MySQL statement that lists all properties whose street name (part of its address) contains 'bay'. Your query should return a table in the following format. Property ID Street Address Suburb List price status List price Task 10. (2+2 = 4 marks) The System supports fuzzy search for properties. Write one (1) SQL statement that lists all properties whose street name (part of its address) starts with character 'M'. Your query should return a table in the following format. Property ID Street Address Suburb State Status State Write another one (1) MySQL statement that lists all properties whose street name (part of its address) contains 'bay'. Your query should return a table in the following format. Property ID Street Address Suburb List price status List price