2A- Given the default schema of a database:EB Orders123 OrderldOrderDateADC OrderNumber123 Customerld123 TotalAmount123 Itemld123 Orderld123 Productld123 UnitPrice123 QuantityOrderltemSelect one:a.O C.EB Customers123 CustomerldADC FirstNameADC LastNameADC Citynoc CountryADC PhoneO d.ProductsWhich WHERE clause should be used to complete the SQL statement below to list the names of customers from Sydney and Melbourne, Australia?SELECT firstName, lastNameFROM Customers123 ProductldADC ProductName123 Supplierld123 UnitPriceADC Package123 IsDiscontinuedSuppliersWHERE Country = 'Australia' AND City = 'Melbourne' AND City = 'Sydney'O b. WHERECountry == 'Australia' AND (City = 'Melbourne' OR City = 'Sydney')WHERECountry = 'Australia' OR (City = 'Melbourne' AND City = 'Sydney')WHERE Country = 'Australia' AND City = 'Melbourne' OR City = 'Sydney'123 SupplierldADC CompanyNameADC ContactNameADC ContactTitleADC Citynoc CountryADC PhoneADC Fax

The question has been answered in step2

Given the default schema of a database: EB Orders 123 Orderld OrderDate ADC OrderNumber 123 Customerld 123 TotalAmount 123 Itemld 123 Orderld 123 Productld 123 UnitPrice 123 Quantity Orderltem Select one: O a. O b. O C. O d. EB Customers 123 Customerld ADC FirstName ADC LastName ADC City ADC Country noc Phone Products 123 Productld ADC ProductName 123 Supplierld 123 UnitPrice ADC Package 123 IsDiscontinued Which WHERE clause should be used to complete the SQL statement below to list the names of customers from Sydney and Melbourne, Australia? SELECT firstName, lastName FROM Customers Suppliers 123 Supplierld ADC CompanyName noc ContactName ADC Contact Title noc City noc Country noc Phone noc Fax WHERE Country = 'Australia' AND City = 'Melbourne' AND City = 'Sydney' WHERE Country = 'Australia' AND (City = 'Melbourne' OR City = 'Sydney') WHERE Country = 'Australia' OR (City = 'Melbourne' AND City = 'Sydney') WHERE Country = 'Australia' AND City = 'Melbourne' OR City = 'Sydney'