Tutor profile: Grant B.
Subject: SQL Programming
How to pull data using an if statement?
If you want to use a sort of "if then" scenario a case function would be how to do it. A case function allows you to write as many conditions as you want and SQL will take your data through each condition until either one is met or none are.
Subject: Python Programming
What are key concepts to know in order to avoid repetitive coding?
Function and loops help avoid coding redundancy and avoid errors. Functions allow you to save a certain action to be done; So that when you need to do said action you can simply call the function rather than type out all the code. Loops are helpful so that certain processes or actions can be taken on a dataset, dictionary or list in python, which saves you from having to perform code on each item.
What is positioning theory?
Positioning theory is the theory that a brand or product holds a specific place in the mind and that brain only has so many positions it can retain for each category. An example is, when I say truck and ask you to think of a brand, whatever brand comes to mind first holds the first position in your mind. The brand in the number one position most likely has some preference to you.
needs and Grant will reply soon.