CREATE a query that will disable Soul Fire (Rank 5) IN Eye OF the Storm, THEN CREATE a query that will remove this disable:
It was very hard TO find Soul Fire (Rank 5), because ALL online DB's got cataclysm spells etc, but I found it in the end. <-- openwow.com

INSERT INTO `disables` VALUES ('0', '47824', (1+16+32), '566', "'820', "Soul Fire Disable");

and

DELETE FROM `disables` WHERE `entry` = '47824';

Create a query that will find ALL creatures in the 'creature' table: between 5478 to 8145 in the "position_x" column, 400 to 2000 in "position_y", and where "position_z" is less than 500. The id must also be one of these:36612, 39168

SELECT * FROM `creature` WHERE `position_x` BETWEEN '5478' AND '8145' AND `position_y` BETWEEN '400' AND '2000' AND `position_z` < 500 AND (`entry` = '36612' OR `entry` = '39168');

Create a query that will sort creature guids, so you will need a query that will move all guids and set them with no free space
                                                                            ^
                                                                            What do you mean by this?


ALTER TABLE `creature` ORDER BY `entry` ASC;
OPTIMIZE TABLE `creature`;