01
SELECT * FROM profile WHERE name = 'frank';
02
SELECT city, lat, lng, stay FROM footprints ORDER BY arrived;
03
SELECT company, title, period FROM experience ORDER BY start DESC;
SELECT * FROM education;
04
SELECT * FROM projects WHERE tag IN ('*') ORDER BY year DESC;
05
SELECT skill, level FROM skills GROUP BY category;
06
SELECT * FROM resume WHERE lang IN ('en', 'zh');
07
SELECT * FROM log ORDER BY created_at DESC;
08
SELECT channel, handle FROM contact;