🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 91:

Company Store Details

MySQL
Find the names of managers and store addresses of the company.
Display the result as a table with the columns: store_id, manager and address.
The manager column should display the last name and the first letter of the name with a dot after it. For example: Silverman B.
Sort the data in ascending order of the store_id field
Expected result Columns: 3 · Rows: 2
store_id manager address

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query