The question in English is as follows: (use left join)

and for about a week I have been wondering how to do this in sql server, I will be very grateful for any help! Here is the DB structure: the link

  • You tried to write the sample yourself? what exactly did you fail? choose the names of the workers? choose the number of orders? - PashaPash ♦
  • @PashaPash the names of the workers will be chosen) it’s impossible to figure out how the condition “during 1997” should look like - DoneBass
  • OrderDate> = '1997-00-00 00: 00: 00.00' and OrderDate <'1998-00-00 00: 00: 00.00' - PashaPash ♦
  • one
    year(OrderDate) = 1997 as an option. - teran
  • one
    @teran thanks, figured out, just add DISTINCT to SELECT 'y - DoneBass

0