Write a SELECT statement that returns four columns based on the InvoiceDate column of the Invoices table:

• Use the CAST function to return the first column as data type varchar.
• Use the CONVERT function to return the second and third columns as a varchar, using style 1 and style 10, respectively.
• Use the CAST function to return the fourth column as data type real.

Sorry, but "sql" does not identify the School Subject for us. Please look to the upper left-hand column in red.

Sra

To write a SELECT statement that returns four columns based on the InvoiceDate column of the Invoices table, follow these steps:

Step 1: Use the CAST function to return the first column as data type varchar.
```sql
SELECT CAST(InvoiceDate AS varchar) AS Column1
```

Step 2: Use the CONVERT function to return the second and third columns as varchar, using style 1 and style 10, respectively.
```sql
SELECT CONVERT(varchar, InvoiceDate, 1) AS Column2,
CONVERT(varchar, InvoiceDate, 10) AS Column3
```

Step 3: Use the CAST function to return the fourth column as data type real.
```sql
SELECT CAST(InvoiceDate AS real) AS Column4
```

Putting it all together, the complete SELECT statement would be:
```sql
SELECT CAST(InvoiceDate AS varchar) AS Column1,
CONVERT(varchar, InvoiceDate, 1) AS Column2,
CONVERT(varchar, InvoiceDate, 10) AS Column3,
CAST(InvoiceDate AS real) AS Column4
FROM Invoices;
```

Make sure to replace "Invoices" with the actual table name in your database.