SQL server query column yes or no

SELECT  a.ID, a.FirstName, a.Lastname,
        CASE WHEN COUNT(b.CustID) > 0 THEN 'YES' ELSE 'NO' END AS HasOrders
FROM    Customer a
        LEFT JOIN Orders b
            ON a.ID = b.CustID        -- <<== the linking column on both tables
GROUP   BY a.ID, a.FirstName, a.Lastname

Similar codes

0 vote252 views3 answers
Average salary in sql
SQL
1 vote238 views1 answer
Import database from a file using mysql commandline
SQL
5 votes261 views2 answers
Add column postgres with default value
SQL
9 votes246 views2 answers
Oracle all tables in schema
SQL
1 vote275 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote287 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote235 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote258 views1 answer
Basic structure of sql expression having clause
SQL
0 vote258 views1 answer
Sql character index
SQL
4 votes289 views1 answer
Postgres delete last row
SQL