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 vote354 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
1 vote350 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote392 views2 answers
Temp tables in sql server
SQL
0 vote377 views1 answer
Oracle plsql sleep
SQL
1 vote328 views2 answers
Into sql
SQL
0 vote342 views1 answer
Import all databases mysql
SQL
16 votes353 views6 answers
Insert sql
SQL
3 votes345 views2 answers
Oracle synonym
SQL
1 vote355 views1 answer
How to update date add hours in postgresql
SQL
0 vote390 views1 answer
View psql output in horizontal scrolling
SQL