This post contains a solutions for the Getting Started with the Platform portion of the Salesforce Platform Basics module of the Admin Beginner trail on Trailhead. Challenge: Create a simple garage manager app using the Force.com App Quick Start Wizard Conditions: Create an app called Garage Your app’s main data type is called “Vehicle” (plural: “Vehicles”)…
October wasn’t a great month for, well, achieving anything at all, really. Still, I can now do the following, which I could not do before: – Create extremely simple interactive python games thanks to Coursera’s Introduction to Interactive Programming in Python (ongoing). – Create and manipulate simple databases using MySQL and SQLite – Write moderately complex queries…
Exercises taken from SQLcourse.com here and here. Review Exercises: GROUP BY How many people are in each unique state in the customers table? Select the state and display the number of people in each. From the items_ordered table, select the item, maximum price, and minimum price for each specific item in the table. How many…
Exercises taken from SQLcourse.com Aggregate functions work over a set of values and are as follows: MIN: returns the smallest value in the set MAX: returns the greatest value in the set SUM: returns the sum of the numeric values in a set AVG: gives the average of a set COUNT: counts total number of…
Taken from SQLCourse.com Review Exercises 1: From the items_ordered table, select a list of all items purchased for customerid 10449. Display the customerid, item, and price for this customer. 2: Select all columns from the items_ordered table for whoever purchased a Tent. 3: Select the customerid, order_date, and item values from the items_ordered table for…
We’re getting on to more tricky stuff! Answers to the SQLzoo tutorial on using SUM, COUNT, MAX, DISTINCT and ORDER BY. 1. List the films where the yr is 1962 [Show id, title] (This one is given to you) 2. Give year of ‘Citizen Kane’. 3. List all of the Star Trek movies, include the…
Answers to the tutorial SQLzoo tutorial: JOIN and UEFA EURO 2012 1. Show matchid and player name for all goals scored by Germany. 2. Show id, stadium, team1, team2 for game 1012 3. Show the player, teamid and mdate and for every German goal. 4. Show the team1, team2 and player for every goal scored…
Answers to SQLzoo’s SUM and COUNT tutorial. 1. Show the total population of the world. 2. List all the continents – just once each. 3. Give the total GDP of Africa. 4. How many countries have an area of at least 1000000. 5. What is the total population of (‘France’,’Germany’,’Spain’)? 6. For each continent show the continent and…
Answers to the SELECT from WORLD tutorial on SQLzoo. 1. Just run the query 2. Show the name for the countries that have a population of at least 200 million. (200 million is 200000000, there are eight zeros) 3. Give the name and the per capita GDP for those countries with a population of at least 200…
Answers to the SELECT Basics tutorial of SQLzoo. 1. Show the population of Germany 2. Show the per capita gdp for each country where the area is over 5,000,000 km2 3. Show the name and continent where the area is less then 2000 and the gdp is more than 5000000000 4. Show the name and the population for ‘Denmark’, ‘Finland’, ‘Norway’, ‘Sweden’ 5. Show each country that begins…
Today’s exercise from thekarangoel’s huge list of github projects. The Collatz Conjecture is defined as follows: Start with a number n > 1. Find the number of steps it takes to reach one using the following process: If n is even, divide it by 2. If n is odd, multiply it by 3 and add…
This code snippet is a solution to the Better Splitting task in the problem set of Unit 4 of Udacity’s Introduction to Computer Science. It will split up a given string source according to whichever characters are specified in splitlist.
I’ve been run off my feet lately and can’t seem to get round to anything. Today I finally had some time to work on a very small project from this list. This program takes an amount (I assumed in EUR) and tells you how much change you get in notes and coins. When I finished…
Naming cell references and ranges A name can be given to a cell reference or range by one of these two methods: Modifying the Name Box – Select a cell or range – In the box which displays the cell reference, type your desired name. Defining a New Name – Go to Insert > Name…
I’ve mentioned that one of the courses I’m following currently is Keith Devlin’s Introduction to Mathematical Thinking on Coursera. Maths is something I was never interested in and never considered myself to be ‘good’ at (hence this blog’s tongue-in-cheek name). Getting yourself out of a mentality where you’ve convinced yourself you’re weak at something or…
Terrible at Maths 