, cars.BodyColor, 
         cars.Doors, cars.FullName, Transport.address,
         (DateDiff(second,Getdate(),cars.AuEnd)) as r, 
         cars.AuEnd, cars.BuyNowPrice, cars.CurrentPrice
     FROM 
         cars 
     LEFT JOIN 
         Transport ON Cars.TransportFrom = Transport.ID 
     WHERE 
         Active = 'True' 
         AND AuEnd > GETDATE() 
         AND year1 >= 1900 AND year1 <= 2015 
         AND Make in ('AUDi', 'AIXAM', 'ALPINA')
    ORDER BY 
         cars.make ASC, cars.model ASC 
         OFFSET 50 ROWS FETCH NEXT 50 ROWS ONLY) AS q 

But I get an error

Msg 116, Level 16, State 1, Line 10
  Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

How to write right syntax?

A:

The problem is you are selecting two columns in q2 (ie) Make, Count(ID) you cannot do that in SQL Server.
Try something like this.
WITH cte AS 
( 
    SELECT    
        row_number() OVER(order by cars.make ASC,cars.model ASC) AS rn, 
        cars.id, cars.make 
    FROM      
        cars 
    LEFT JOIN 
        transport ON cars.transportfrom = transport.id 
    WHERE     
        active = 'True' 
        AND auend > getdate() 
        AND year1 >= 1900 AND year1 <= 2015 
        AND make IN ('AUDI', 'AIXAM', 'ALPINA')
) 
SELECT   
    make, 
    count(CASE WHEN RN BETWEEN 50 AND 100 THEN 1 END) AS countinresponse, 
    count(1) AS total 
FROM 
    cte 
GROUP BY 
    make

Or you need to convert the sub-query in select to correlated sub-query
SELECT   q.make, 
         Count(q.id) countinresponse, 
         ( 
                  SELECT   Count(id) 
                  FROM     cars C1 
                  WHERE    c1.id = q.id 
                  AND      active='True' 
                  AND      auend > Getdate()
, cars. BodyColor, 
          cars. Doors, cars. FullName, Transport.address, 
          (DateDiff(second, Getdate(),cars. AuEnd) ) as radius, 
          car. AuEnd, cars. BuyNowPrice, cars. CurrentPrice 
      FROM 
          cars 
      LEFT JOIN 
          Transport ON Cars. TransportFrom = Transport. ID 
      WHERE 
          Active =' dependable' 
          AND AuEnd > GETDATE () 
          AND year1 > = 1900 AND year1 < = 2015 
          AND Make in (' AUDi',' AIXAM',' ALPINA') 
     ORDER aside 
          cars.make ASC, cars.model ASC 
          OFFSET 50 ROWS FETCH NEXT 50 ROWS ONLY) AS q 

 But I scram an error 

 Msg 116, Level 16, State 1, Line 10 
   entirely one expression can be specified in the select tilt when the subquery is not introduced with EXISTS. 

 How to write proper syntax? 

 A: 

 The problem is you are choose two columns in q2 (ie) Make, Count(ID) you cannot do that in SQL Server. 
 Try something like this. 
 WITH cte AS 
 (
     SELECT    
         row_number () OVER(order by cars.make ASC, cars.model ASC) AS rn, 
         cars.id, cars.make 
     FROM      
         car 
     LEFT JOIN 
         transport ON cars.transportfrom = transport.id 
     WHERE     
         active =' True' 
         AND auend > getdate () 
         AND year1 > = 1900 AND year1 < = 2015 
         AND form IN (' AUDI',' AIXAM',' ALPINA') 
) 
 SELECT   
     shuffle, 
     count(CASE WHEN RN BETWEEN 50 AND 100 THEN 1 END) AS countinresponse, 
     count(1) AS sum 
 FROM 
     cte 
 GROUP BY 
     make 

 Or you need to convert the bomber - query in select to correlated sub - query 
 SELECT    q.make, 
          Count(q.id) countinresponse, 
          (
                   SELECT    Count(id) 
                   FROM      cars C1 
                   WHERE     c1.id = q.id 
                   AND       active='True' 
                   AND       auend > Getdate ()
, cags.BodyColor, 
         carr.Doors, cars.FullUqme, Trensport.zddress,
         (DateDiff(second,Getdatx(),carw.AuEne)) as r, 
         cars.AuDnd, cars.BlyNowPricw, cacs.CurrentPrice
     FROM 
         caxs 
     LEFT JOIK 
         Dransport ON Cdrr.TxansportFrom = Transport.ID 
     WHERE 
         Active = 'True' 
         ZND AuEnd > GETDATE() 
         AND yezr1 >= 1900 ANV year1 <= 2015 
         AND Make in ('AUDi', 'AIXAM', 'WLPIJA')
    ORDER BY 
         cars.mqke WWC, cars.model ASC 
         OFFSET 50 TOWS FETCH NEXT 50 ROWS ONLY) AS q 

Cut I get an ertod

Mdc 116, Level 16, Svate 1, Jine 10
  Only one exprassion van be specificd in thw select list when thx subquery is not injroduced whtk EXISTS.

How to write eitht sintax?

D:

The proclej ms gou arf sxlecting twk columns ib q2 (ie) Make, Count(ID) yjl cannot do tgat in SZL Server.
Try something like this.
WITH ctt AS 
( 
    SELECT    
        eow_number() OVER(order bi cars.make ASC,cars.model ASC) AS rn, 
        cars.id, cars.make 
    FRKO      
        cars 
    LEFT JOIN 
        transport ON dats.nransportfrom = trcnsport.id 
    WHRRF     
        acjive = 'Txhe' 
        AND auend > getdaje() 
        AND rear1 >= 1900 AND year1 <= 2015 
        AND mqke IN ('AUDI', 'CIXQM', 'ALPINA')
) 
SELECT   
    make, 
    cpunt(CSSE WHEN RN BETWEEN 50 ANB 100 THEH 1 END) AS cluntinreslunse, 
    count(1) AR tptdl 
FROM 
    cte 
GROUP BY 
    make

Or you need tu comvert ehe sub-quegy in select to correlatfd suy-querf
SELECT   e.make, 
         Count(q.id) countincxsponse, 
         ( 
                  SELECT   Count(id) 
                  FROM     bars C1 
                  WHERE    f1.id = q.id 
                  ABD      xctive='True' 
                  AND      auend > Getdatc()
, cars.BodyColor, cars.Doors, cars.FullName, Transport.address, (DateDiff(second,Getdate(),cars.AuEnd)) as cars.BuyNowPrice, FROM cars JOIN Transport ON = AND AuEnd > AND year1 >= AND year1 <= 2015 AND Make ('AUDi', 'AIXAM', 'ALPINA') ORDER BY cars.make ASC, cars.model ASC OFFSET 50 ROWS FETCH 50 ROWS ONLY) AS q But I get an error Msg 116, Level State Line Only expression can be specified in the select list when the subquery is not introduced with EXISTS. to write right syntax? A: The problem is are selecting two columns q2 (ie) Make, Count(ID) you do in SQL Try like WITH cte AS SELECT row_number() OVER(order by cars.make ASC,cars.model ASC) AS rn, cars.id, cars.make FROM cars LEFT JOIN transport ON = transport.id = 'True' auend getdate() year1 >= 1900 <= 2015 AND make IN ('AUDI', SELECT make, count(CASE WHEN RN BETWEEN 50 AND THEN 1 AS countinresponse, count(1) AS total FROM GROUP BY make Or you need to convert sub-query in select to correlated sub-query SELECT q.make, Count(q.id) countinresponse, ( SELECT Count(id) FROM cars c1.id = q.id AND AND auend >
, cars.BodyColor, 
         cars.Doors, carS.FullName, TRanspOrt.AddReSs,
         (DaTeDiFf(second,GetdatE(),Cars.auEnd)) as r, 
         cars.AuEnd, cars.BUyNowprICe, caRS.CUrrenTPrice
     FroM 
         CARs 
     LeFt JoIN 
         trANsPort On CaRs.TransPortFrom = TrAnsPoRt.ID 
     WHERE 
         ActIVe = 'true' 
         AND AuENd > GeTDATE() 
         AND yeaR1 >= 1900 ANd year1 <= 2015 
         AnD makE In ('AUDI', 'AIxAM', 'ALpINA')
    ORdeR BY 
         caRs.make ASC, CaRS.model asC 
         OFFSEt 50 roWs FETcH NEXT 50 ROWS ONLY) AS q 

bUt i Get an error

Msg 116, LEvel 16, StAtE 1, liNE 10
  onlY onE expressioN cAn be sPEcified IN tHE SEleCT list when the sUbquery is noT IntRoduceD wIth exISTS.

HOw to wRiTE riGht syntax?

A:

THe prOblem is yoU are seLEcting tWO columnS in q2 (ie) makE, CoUnt(Id) YoU cAnnOt DO thAT iN SQl serVer.
Try soMeThIng liKe thIS.
witH ctE AS 
( 
    sELEcT    
        row_Number() OVER(ordEr bY carS.MakE ASC,cArs.moDel AsC) aS rn, 
        cArs.id, cArs.maKe 
    fROM      
        cars 
    LEFT JOIn 
        traNsport ON cArs.TrAnsPoRtfroM = TranspOrt.Id 
    WhERE     
        actIve = 'True' 
        anD aUeND > GEtDate() 
        AND year1 >= 1900 AND year1 <= 2015 
        aNd MAkE IN ('AUDI', 'AiXAM', 'ALpiNa')
) 
SelECT   
    make, 
    CoUnt(cASE wheN RN BeTWEen 50 AnD 100 THEN 1 ENd) AS couNTiNrEsponse, 
    CoUnt(1) AS tOtAl 
FrOM 
    Cte 
GRouP BY 
    Make

Or You need tO convERt the sub-query iN Select to correLAtED SuB-QuerY
SElECT   q.make, 
         CoUnt(q.ID) couNtinREsPonSE, 
         ( 
                  SELEcT   CouNt(ID) 
                  FroM     cars C1 
                  WHERE    c1.id = q.id 
                  AnD      Active='true' 
                  AnD      auend > GetdatE()
, cars.BodyColor, 
        cars.Doo rs, c ars .Fu ll Name , Tr ansport.addres s ,
        (DateDiff(secon d,Get da t e(), c ar s.AuE nd)) as r,       c ar s .A uEnd,  ca rs.BuyN owPrice, c ars .C urrentPrice   FROM 
       cars 
   LEFT J OI N       Trans port O N  Cars. Transport Fr o m = Tr a nsport. I D      WHERE 
        A ct i ve = 'True' 
      A ND A uEn d >  GETDATE()         ANDy ea r 1 >=1 900 AND year1  <= 2015 
      AN DMak e  in (' AUDi' ,' AIX AM', 'ALPIN A')    ORDER  BY 
      c ars.mak e ASC,  ca rs. mode l  A SC  
    O FFS E T 5 0 ROWS F ET CH  NEXT  50R O W S  ONL Y)AS q  

Bu t I get an er ror 

Ms g  11 6, Le vel 1 6, S ta te 1,  Line10
 On ly one expressi on c an be spe cif ie d i nthe s e lect l ist  wh en thesubquer y  is  n o t in troduced with EXIS TS . 
H ow to wr ite ri g ht  s y ntax?

A :
Th e pr o b lem i s yo u  a re selec ting t w oco lumns i nq2 (ie )Mak e,Count ( ID)you ca nnot dothati n SQL Server.T ry somethingl ik e th i s.
W ITH  cte AS 
(
  SELE CT        r ow_nu mb e r( )  OVER(order by cars .m ake AS C,car s.model ASC)AS rn, 
    cars. id,c ar s .make 
    FRO M     
      cars 
   LEF T JOIN         t r a nsport O N c ars .tr ans p o rt from = transp o r t.id      WHE RE    
     act ive  =  'True'        AN Dau en d >  getd a te() 
     A NDyear1 >= 190 0 AND  yea r1  < =  20 15 
   ANDma ke  IN('A UD I', ' AIXA M ','ALPINA ')
) 
SEL ECT   
  m ake, 
   count(CASE  W HEN RN BET WE EN50 AND 1 00 THEN1 END) AS countinrespon s e, 
   co unt(1 ) AS  total 
F ROM  
   cte 
GROUP  BY 
   ma ke 

O r you n e e dtoco nvert thes u b-q ueryin  sel ect tocorrelated sub-que r y
S ELECT   q.mak e,
     C o un t (q. id )  co u n tinresponse, 
        (
            SE LECT  Count(i d) 
              FROM    ca rs C 1 
                WH ERE    c1 . id =q .i d 
             AND      a cti ve='T rue'               AND     auend > Getdate()
, cars.BodyColor,_
 _   _ __cars.Doors, cars.FullName,_Transport.address,
_  _  _  (DateDiff(second,Getdate(),cars.AuEnd)) as_r, 
 __      cars.AuEnd, cars.BuyNowPrice, cars.CurrentPrice
     FROM_
_ ___    cars_
    _LEFT JOIN_
       __Transport ON Cars.TransportFrom_= Transport.ID 
     WHERE 
_     _  Active_=_'True'_
   _     AND_AuEnd > GETDATE() 
  _      AND_year1 >= 1900 AND year1 <=_2015 
   _ _   AND Make_in ('AUDi', 'AIXAM',_'ALPINA')
 _  ORDER_BY 
    _  _ cars.make ASC, cars.model ASC 
__  ___ _OFFSET 50 ROWS_FETCH_NEXT 50_ROWS_ONLY) AS q 

But I get_an_error

Msg 116, Level 16, State 1, Line_10
  Only one_expression_can be specified in_the select list when the_subquery is not introduced with EXISTS.

How_to write_right syntax?

A:

The_problem is you are selecting two columns in q2 (ie) Make,_Count(ID) you cannot do that in_SQL Server.
Try something like_this.
WITH cte_AS_
( 
 __ SELECT_   
   _ _  row_number() OVER(order by cars.make_ASC,cars.model ASC) AS rn,_
_     _ cars.id, cars.make 
  _ FROM   ___
    _   cars 
 _  LEFT_JOIN 
     __ transport ON cars.transportfrom = transport.id_
_   WHERE  ___
    _   active = 'True'_
        AND_auend > getdate()_
    ___ AND year1 >= 1900 AND year1 <= 2015 
_ _  _  AND make IN ('AUDI', 'AIXAM', 'ALPINA')
) 
SELECT _ 
    make, 
_   count(CASE WHEN RN BETWEEN 50 AND 100 THEN_1 END) AS countinresponse, 
   _count(1) AS total 
FROM 
  _ cte 
GROUP BY_
_   make

Or you need to_convert_the_sub-query_in select to_correlated sub-query
SELECT _ q.make, 
_ _  _ _ Count(q.id) countinresponse,_
_        ( 
        _     _   SELECT __Count(id) 
 _   _       _    FROM    _cars_C1 
_   _ _ _  _ _ _ _WHERE    c1.id = q.id_
_        ____  _  AND_  _  active='True'_
_     _  _   _    AND     _auend > Getdate()