How to Use the SUM Function in MySQLIn Feburary 2016 19,

In Feburary 2016 19,
Use the SUM aggregate function. SUM will add all of the selected columns together.
Notice how, in this example, you'll sum all of the negative balances to calculate the total amount owed to you by your customers. The result returns in a column called SUM(balance). Example:
SELECT SUM(balance) FROM customers WHERE balance
Use the AVG Function in MySQL
Use the AVG aggregate function. This aggregate is similar to SUM. However, instead of adding the columns, it adds them and then divides by the total number of columns, giving you an average of the column values.
Use AVG in much the same way SUM is used. Here, the example calculates the average amount of money owed by customers. Results return in a column called AVG(balance). Example:
SELECT AVG(balance) FROM customers WHERE balance
Use the COUNT Function in MySQL
Use the COUNT aggregate function. This function is slightly different than SUM or AVG. It returns the number of rows returned, which can be useful in a number of situations--for example, to see the number of customers who owe money.
See how this example counts the customers who owe money and returns the result in a column called COUNT(
). Example:
SELECT COUNT(
) FROM customers WHERE balance
Use the DISTINCT COUNT Function in MySQL
Use the DISTINCT COUNT aggregate function. The function can be used to return the number of distinct rows, meaning those rows with differing values. Theoretically, you might have a lot of customers with the same phone number. To get the number of households your customers live in, you can use this type of query.
Use the following example to return the number of customers with distinct phone numbers. Customers with the same phone number will not be counted. The results are returned in a column called COUNT(DISTINCT ph_number). Example:
SELECT COUNT(DISTINCT ph_number) FROM customers;
In Feburary 2016 19,

How to Play ROMs on iPhoneIn Feburary 2016 13,

In Feburary 2016 13,
Launch Cydia and add the following 'Repository': 'http://thebigboss.org". To add a repository, launch 'Cydia' and click on 'Manage' then 'Sources.' On that screen, click 'Edit' (top right screen) and then 'Add' (top left). Let the application reload after it adds the source.
Click on 'Sections' in Cydia and look for 'Emulators.' Tap on that and you will see emulators for the original Nintendo, Super Nintendo, Gameboy, Gameboy Color, Gameboy Advance and Sega Genesis. The iPhone will not handle any other ROMs because of graphical issues. Install the emulator of your choice and let it download and install.
Connect the iPhone to the computer and close out of iTunes if it is set to pop up. Download the free program iPhone Browser (see Resources below). This will allow you to see all the hidden files on your iPhone. Launch this application after it installs and use it to navigate to /private/var/root/Media/ROMs/. Copy any ROMs you have downloaded (there is a site to download ROMs in the Resources section) to this location under whatever folder the ROM is for. If it is a Gameboy Advance ROM, you will copy it to the folder 'Gameboy Advance Roms.'
Disconnect your iPhone and launch your emulator application. If you put the ROMs in the correct folder, it will detect them and you can play them. Some of the emulators will even allow you to play the game with the iPhone in landscape (sideways) mode.
In Feburary 2016 13,