Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select store, category, brand, model, normalPrice, offerPrice, minimumPrice, hasStock from product where ROUND(normalPrice/3) > offerPrice and offerPrice > 0;
- +--------+------------+----------+-----------------------------------------+-------------+------------+--------------+----------+
- | store | category | brand | model | normalPrice | offerPrice | minimumPrice | hasStock |
- +--------+------------+----------+-----------------------------------------+-------------+------------+--------------+----------+
- | Paris | smartphone | Sim | Card ChatSim | 99990 | 29990 | 29990 | 1 |
- | Abcdin | smartphone | LG | X Max Titan | 169990 | 49990 | 49990 | 0 |
- | Abcdin | smartphone | Huawei | Ascend Y511 Negro Movistar | 69990 | 19990 | 19990 | 0 |
- | Abcdin | smartphone | Samsung | Grand Prime VE Gris Movistar | 149990 | 49990 | 49990 | 0 |
- | Abcdin | smartphone | Motorola | Moto G 3ra Generaci�n Negro Movistar | 189990 | 59990 | 59990 | 0 |
- | Abcdin | smartphone | Azumi | A40C Style Blanco Claro | 59990 | 14990 | 14990 | 0 |
- | Abcdin | notebook | Notebook | HP 14" Intel Pentium, 4GB RAM, 500GB DD | 249990 | 79990 | 79990 | 0 |
- +--------+------------+----------+-----------------------------------------+-------------+------------+--------------+----------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement