content.knowledify.com
Suming bits | Explore Knowledify
http://www.content.knowledify.com/deck/62
As the number of songs being provided to the customer is increasing, the provisioning department needs more reporting to be done. As you have done a terrific work with them before, they have naturally turned to you. This assignment will cover the basic aggregate. Operators such as COUNT. You will be working again on the track. Group 'em all. Check out Google Play.
content.knowledify.com
Prime Conditions | Explore Knowledify
http://www.content.knowledify.com/deck/8
The Marketing department has come back to you regarding your initial data selection job. They are happy by your work and would like to perform additional customer segmentation before their next campaign. You will still be using the customer. Table It would the perfect occasion to demonstrate your skills with most complex search conditions such as BETWEEN. Group 'em all. Check out Google Play.
content.knowledify.com
Group 'em all | Explore Knowledify
http://www.content.knowledify.com/deck/133
Group 'em all. You have been called back by the financial department that wants to analyse the outcome distribution generated by their customers. This assignment will allow you to put in good use the aggregate functions. In combination with the grouping. Operator and the group filter. Operator. You will be therefore working solely on the Customer. Group 'em all. Check out Google Play.
content.knowledify.com
Compound Commands | Explore Knowledify
http://content.knowledify.com/help/and-or
We have seen that the WHERE. Keyword can be used to conditionally select data from a table. This condition can be a simple condition (like the one presented in the previous section), or it can be a compound condition. Compound conditions are made up of multiple simple conditions connected by AND or OR. There is no limit to the number of simple conditions that can be present in a single SQL statement. The syntax for a compound condition is as follows:. Table, we key in:. Check out Google Play.
content.knowledify.com
True or False? | Explore Knowledify
http://www.content.knowledify.com/deck/167
You did well so far. You will continue using the Customer. Table as to solve the search query of the department. This time, you will need to use compound. Expressions and the NOT. Operator to tackle new challenges. Let's get the ball rolling. Group 'em all. Check out Google Play.
content.knowledify.com
Order By | Explore Knowledify
http://content.knowledify.com/help/ORDERBY
So far, we have seen how to get data out of a table using SELECT. Commands. Often, however, we need to list the output in a particular order. This could be in ascending order, in descending order, or could be based on either numerical value or text value. In such cases, we can use the ORDER BY keyword to achieve our goal. The syntax for an ORDER BY statement is as follows:. SELECT "column name" FROM "table name" [WHERE "condition"] ORDER BY "column name" [ASC, DESC];. Ordering by Column Position. In addi...
content.knowledify.com
Bringing order | Explore Knowledify
http://www.content.knowledify.com/deck/22
Marketing has come back to you, and would like to get extracts from their customer base sorted in specific ways. It is time now to practice on the ORDER BY. You will still use one table, the customer. Table Keep up the good work; rumors are saying that you may soon moving up with the company! Group 'em all. Check out Google Play.
content.knowledify.com
Distinct | Explore Knowledify
http://content.knowledify.com/help/distinct
Keyword allows us to grab all information from a column (or columns) on a table. This, of course, necessarily means that there will be redundancies. What if we only want to select each DISTINCT element? This is easy to accomplish in SQL. All we need to do is to add DISTINCT after SELECT. The syntax is as follows:. SELECT DISTINCT "column name" FROM "table name";. For example, to select all distinct stores in table stores. SELECT DISTINCT name FROM store. Group By and Distinct. A DISTINCT and GROUP BY.
content.knowledify.com
Project into | Explore Knowledify
http://www.content.knowledify.com/deck/93
You have now moved to another service of Essential Stream: the provisioning service. Their activities consist in maintaining a portfolio of songs available for customers to buy. You will start working on the Track. Table This table contains the name of the song, its price, as well as its length in milliseconds. And its size in bytes. This assignment will be the opportunity to work on aliasing. Note that all the numbers are stored as floats. Group 'em all. Check out Google Play.
content.knowledify.com
Null | Explore Knowledify
http://content.knowledify.com/help/null
In SQL, NULL means that data does not exist. NULL does not equal to 0 or an empty string. Both 0 and empty string represent a value, while NULL has no value. Any mathematical operations performed on NULL will result in NULL. For example,. Aggregate functions such as SUM. Exclude NULL values. This is not likely to cause any issues for SUM, MAX, and MIN. However, this can lead to confusion with AVG and COUNT. Let's take a look at the following table store. Below are the results for each aggregate function:.
SOCIAL ENGAGEMENT