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

1 vote233 views1 answer
Is sql fast
SQL
0 vote187 views1 answer
Enable sql server full text indexing
SQL
0 vote206 views1 answer
Testing sql queries
SQL
0 vote182 views1 answer
Conda install pymysql "windows"
SQL
0 vote208 views1 answer
Get only one row in mysql
SQL
1 vote178 views2 answers
Mysql extract month
SQL
0 vote140 views1 answer
Oracle function select into
SQL
2 votes169 views1 answer
Add 2 hours to current time in MySQL
SQL
1 vote174 views1 answer
Mysql check if string contains comma separated
SQL
1 vote178 views3 answers
Sql select only time from datetime
SQL