Elon decided to give out premium subscriptions for free to some of the users. Consider the...

Transcribed Image Text:

Elon decided to give out premium subscriptions for free to some of the users. Consider the following database schema for a social media platform: Users User Interest Name Userld FirstName VARCHAR(255) UserInterest VARCHAR(255) LastName VARCHAR(255) PhoneNumber VARCHAR(255) Type INT Name Type INT Userld Write an SQL query that returns the FirstName, LastName and PhoneNumber of users whose • FirstName starts with 'e', or LastName starts with 'm', or PhoneNumber starts with '628'. and • User Interest contains 'Driving'. Return the results in descending order by FirstName and PhoneNumber. Elon decided to give out premium subscriptions for free to some of the users. Consider the following database schema for a social media platform: Users User Interest Name Userld FirstName VARCHAR(255) UserInterest VARCHAR(255) LastName VARCHAR(255) PhoneNumber VARCHAR(255) Type INT Name Type INT Userld Write an SQL query that returns the FirstName, LastName and PhoneNumber of users whose • FirstName starts with 'e', or LastName starts with 'm', or PhoneNumber starts with '628'. and • User Interest contains 'Driving'. Return the results in descending order by FirstName and PhoneNumber.

Answer rating: 100% (QA)

You can use the following SQL query to retrieve the FirstName LastName and PhoneN... View the full answer