I have table department_statistics with the following structure and sample data :

DEPT_ID     SAMPLES_MORNING    TESTS_MORNING    SAMPLES_EVENING TESTS_EVENING  DATE 
  1               50              200                75             160        6/12/2024
  2               53              210                79             120        6/12/2024
  3               40              100                35             110        6/12/2024
  1               50              200                75             160        6/13/2024
  2               43              110                79             100        6/13/2024
  3               40              100                35             110        6/13/2024

I need the output of query like this :

DEPT_ID       6/12/2024                                          6/13/2024
  1      sum_samples_morning  sum_samples_evening         sum_samples_morning  sum_samples_evening    
  2      sum_samples_morning  sum_samples_evening         sum_samples_morning  sum_samples_evening
  3      sum_samples_morning  sum_samples_evening         sum_samples_morning  sum_samples_evening

how can I do that and thank you in advance