Ad
Code
Diff
  • w='hello'
    print(w,'\n',len(w))
    • print('hello', len('hello'), '
    • ')
    • w='hello'
    • print(w,'
    • ',len(w))
Code
Diff
  • -- Code Here
    SELECT total_price
    FROM transactions
    WHERE Customer IS NOT NULL
    ORDER BY total_price DESC
    • -- Code Here
    • SELECT
    • *
    • SELECT total_price
    • FROM transactions
    • WHERE Customer IS NOT NULL
    • ORDER BY store, total_price DESC
    • ORDER BY total_price DESC
Code
Diff
  • -- Code Here
    
    select city_name, 
      sum(confirmed_cases) confirmed_cases , 
      sum(recovered_cases) recovered_cases, 
      sum(death_cases) death_cases
    from cases c
    join dati d
      on d.code = c.dati_code
    group by city_name
    order by confirmed_cases desc
    
      
    • -- Code Here
    • select
    • city_name,
    • select city_name,
    • sum(confirmed_cases) confirmed_cases ,
    • sum(recovered_cases) recovered_cases,
    • sum(death_cases) death_cases
    • from cases
    • join dati
    • on dati.code = cases.dati_code
    • from cases c
    • join dati d
    • on d.code = c.dati_code
    • group by city_name
    • order by confirmed_cases desc