Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select store, category, brand, model, normalPrice, offerPrice, minimumPrice, round(normalPrice/4) from product where ROUND(normalPrice/4) > offerPrice and offerPrice > 0;
- +--------+------------+-------+-------------------------+-------------+------------+--------------+----------------------+
- | store | category | brand | model | normalPrice | offerPrice | minimumPrice | round(normalPrice/4) |
- +--------+------------+-------+-------------------------+-------------+------------+--------------+----------------------+
- | Abcdin | smartphone | Azumi | A40C Style Blanco Claro | 59990 | 14990 | 14990 | 14998 |
- +--------+------------+-------+-------------------------+-------------+------------+--------------+----------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement