SELECT u.urun_adi, u.stok_miktari, u.alis_fiyati, u.satis_fiyati, 
        (u.stok_miktari * u.alis_fiyati) as toplam_deger,
        CASE 
            WHEN u.stok_miktari <= 10 THEN "Kritik"
            WHEN u.stok_miktari <= 50 THEN "Düşük"
            ELSE "Normal"
        END as stok_durumu
 FROM urunler u 
 WHERE u.stok_miktari >= ? AND u.stok_miktari <= ?
 ORDER BY u.stok_miktari ASC