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 vote175 views1 answer
Sql trying to delete database in use
SQL
0 vote196 views1 answer
Postgres - Login and connect as default user
SQL
4 votes160 views1 answer
Mac install mysql
SQL
4 votes174 views1 answer
Alter session set nls_date_format
SQL
0 vote177 views1 answer
Get primary key of table
SQL
19 votes196 views6 answers
Create table sqlite
SQL
0 vote164 views1 answer
Mysql page segment
SQL
0 vote164 views1 answer
Alter table name including schema
SQL
0 vote163 views1 answer
Excute raw query
SQL
0 vote200 views1 answer
Implode in sql query
SQL