Can Anyone help me in this SQL Solution? I am a beginner in SQL.

Question

Please Help, cause I am a beginner.
This is the Problem👇

https://www.sololearn.com/coach/985?ref=app

At the conclusion of a bank transaction, 6 checks are printed -- 3 originals for the bank, and 3 copies for the customer.
Here is the list of all the checks named Operation:
Write a query to show only the unique checks that are given to the customer.

Hint : Use the DISTINCT statement to return the unique values of mentioned column.

/* table name: Operation */

SELECT DISTINCT operation.checks, operation.Check1, operation.Check3, operation.Check2
FROM Operation;

Answer 1

Here It Is👇

/* table name: Operation */

SELECT DISTINCT operation.checks, operation.Check1, operation.Check3, operation.Check2
FROM Operation;

It is showing "Operation.check1" does not exists.

Answer 2

first we need to select distinct (unique) values then table name & at last add order by for sorting alphabatecally.
SELECT DISTINCT checks
FROM Operations ORDER BY checks ASC;

Answer 3

SELECT DISTINCT checks
FROM Operation;

Try to make your Query Simpler!!

Answer 4

It's
SELECT DISTINCT checks
FROM Operation;

I felt bad when I understood it

Answer 5

I am facing a similar problem

SELECT DISTINCT checks OPERATIONCHECKs1,OPERATIONCHECKS3,OPERATION.CHECKS2 from OPERATION
The error says that check 3 does not exist