Calculations

- New programmers often make the mistake…of pulling a selection from a database,…then performing calculations in an external language.…Here's an example of this mistake with PHP and MySQL.…Here, we're connecting to a MySQL database in PHP.…MySQL returns a full table of IDs,…first names, and last names.…Then, in PHP, we could go through each row of that data…and calculate some values based on each row…and average or perhaps a count of unique entries,…but in the case of MySQL, it's much more efficient…to perform that operation inside the database.…

Here's an example with MySQL.…All database languages provide rudimentary data…aggregation commands such as sum, average, or count.…In this challenge, each instructor is being asked…to forecast the educational demand for California…up to the year 2060.…We will provide them with two data sets.…The California Educational Attainment & Personal Income…will provide education information…and California Population Projection by County, Age,…Gender, and Ethnicity will provide population forecasts…