this is sqlselect * from abstractproduct a, specification s where a.abstractproduct_id=s.product_id and 1 AND upper(a.brand_name) = 'NOKIA' order by a.abstractproduct_id desc
Nokia is a leading mobile manufacturer since the edge of inception of mobile phone. But nokia get deemed after 2010 again it comes in light when HMD global take over Nokia and comes with nokia 6. We have list down all the mobile phones of nokia.
|Nokia Mobiles price list||Price|
|Microsoft NOKIA 222 D||2849.000|
|Nokia Asha 311||5199.000|
|Nokia Asha 20||2599.000|
|Nokia 108 Dual SI||1800.000|
|Nokia Asha 502||3499.000|