rosousa

# study stream aliases
# Requires https://github.com/caarlos0/timer to be installed. spd-say should ship with your distro

declare -A pomo_options
pomo_options["work"]="45"
pomo_options["break"]="10"

pomodoro () {
  if [ -n "$1" -a -n "${pomo_options["$1"]}" ]; then
  val=$1

rosousa

--Q1:

SELECT COUNT("endDate") "currentExperience" FROM experiences;

--Q2:

SELECT "userId" id, COUNT(*) "educations" FROM educations GROUP BY "userId";

--Q3:

rosousa

--Q1:

SELECT users.id, users.name, cities.name AS city FROM users JOIN cities ON users."cityId" = cities.id WHERE cities.name = 'Rio de Janeiro';

--Q2:

SELECT testimonials.id, writer.name AS writer, recipient.name AS recipient, testimonials.message FROM testimonials JOIN users AS "writer" ON testimonials."writerId" = writer.id JOIN users AS recipient ON testimonials."recipientId" = recipient.id;

--Q3: