RelativeTech

select p.project_name, sum(w.compensation) as TotalComp
from project p, worker w, project_worker_map m
where m.project_id = p.id
and m.worker_id = w.id
and m.worker_id in (
    select id from worker where worker_code in('CODE-1', 'CODE-2')
    )
group by p.project_name

RelativeTech

create table workerX (id integer not null, name varchar(255), compensation double not null, manager_id integer not null)

RelativeTech

insert into workerX (id, name, compensation, manager_id) values (1, 'One First', 50000, 5)
insert into workerX (id, name, compensation, manager_id) values (2, 'Two Second', 70000, 5)
insert into workerX (id, name, compensation, manager_id) values (3, 'Three Third', 90000, 5)
insert into workerX (id, name, compensation, manager_id) values (4, 'Four Fourth', 180000, 5)
insert into workerX (id, name, compensation, manager_id) values (5, 'Five Fifth', 160000, 9)

RelativeTech

select employee.*
from workerX employee, workerX manager
where employee.manager_id = 
and employee.compensation > manager.compensation

RelativeTech

function formatValue(ctx, value, recurseTimes) {
  // Provide a hook for user-specified inspect functions.
  // Check that value is an object with an inspect function on it
  if (ctx.customInspect &&
      value &&
      isFunction(value.inspect) &&
      // Filter out the util module, it's inspect function is special
      value.inspect !== exports.inspect &&
      // Also filter out any prototype objects using the circular check.

RelativeTech

Front-End Performance Checklist

🎮 The only Front-End Performance Checklist that runs faster than the others.

RelativeTech

    class GraphNode {
      constructor(val) {
        this.val = val;
        this.neighbors = [];
      }
    }

    let a = new GraphNode("a");
    let b = new GraphNode("b");

RelativeTech

Appearance

The outward or visible aspect of a website.

• Animation: The process of creating motion and shape change.
  • Animate.css: Just-add-water CSS animations.
  • Animate.less: A bunch of cool, fun, and cross-browser animations converted into LESS for you to use in your Bootstrap projects.
  • Anime.js: Anime is a flexible yet lightweight JavaScript animation library. It works with CSS, Individual Transforms, SVG, DOM attributes and JS Objects.
• Approach: A jQuery plugin that allows you to animate CSS properties based on distance to an object.