SELECT musteri, SUM(ciro) FROM satislar
  WHERE yil = 2024 GROUP BY musteri;

SELECT * FROM projeler
  WHERE durum = 'aktif' AND oncelik = 1;

UPDATE stok SET miktar = miktar - @adet
  WHERE urun_id = @id;

CREATE INDEX idx_fatura
  ON fatura_detay(tarih, musteri_id);

EXEC sp_analiz_raporu
  @baslangic = '2024-01-01',
  @bitis = '2024-12-31';

SELECT KPI, hedef, gerceklesen,
  ROUND(gerceklesen/hedef*100,1) oran
FROM performans_ozet;