icarcal

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

icarcal

ln -sf "Code - OSS (headmelted)" "Code - OSS"

sudo ln -sf "/usr/share/code-oss/bin/code-oss" "/usr/share/code-oss/bin/code"

icarcal

2. Selecionar o preço do livro cujo preço seja maior que 50 e a sigla seja BAN

select
	liv_preco
from
	livro
where
	ass_sigla = 'ban'
and liv_preco > 50

icarcal

1. Exibir os pilotos que são do país Brasil.

select
	a.*
from
	tb_piloto a
inner join
	tb_pais b
on
	a.id_pais = b.id_pais

icarcal

var rick = 'Rick';

icarcal

var rick = 'Rick';
var morty = 'Morty';
var earth = 'C31';

function rickAndMorty() {
  // global context
  console.log(`These ${this.rick} & ${this.morty} belongs to earth ${this.earth}`);
}

var earthC39 = {

icarcal

var rick = 'Rick';
var morty = 'Morty';

function rickAndMorty() {
  console.log(`My favourite show is ${this.rick} & ${this.morty}`)
}

rickAndMorty()
// My favourite show is Ricky & Morty

icarcal

Project Title

One Paragraph of project description goes here

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.

Prerequisites