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 vote314 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote333 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
50 votes408 views6 answers
Sql duplicate rows
SQL
2 votes343 views1 answer
Flask sqlalchemy boolean field
SQL
2 votes327 views2 answers
Postgres select duplicate columns
SQL
-1 vote317 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote322 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote317 views2 answers
How to see table associated with a schema in sql
SQL
0 vote305 views1 answer
Mysql with
SQL
0 vote355 views1 answer
Oracle sql alter view add column
SQL