Jiyu
  • Blog
  • Dev
  • Leetcode
  • |
  • 中文

607. Sales Person

April 7, 2022
sql

Sales Person - LeetCode1


  • code
select name from SalesPerson where sales_id not in (select o.sales_id
from Orders o join Company c on c.com_id = o.com_id where c.name = 'RED' )
« 1511. Customer Order Frequency
923. 3Sum With Multiplicity »
    array 93
    backtracking 20
    bfs 24
    bible 1
    binarysearch 27
    binarysearchtree 14
    binarytree 25
    bit 17
    china 5
    christian 5
    design 8
    dfs 30
    docker 2
    documentary 2
    dostoevsky 1
    dp 41
    dynalist 3
    flask 1
    graph 11
    greedy 16
    hashtable 22
    health 1
    heap 15
    hugo 3
    intellij 2
    java 8
    javascript 1
    leetcode-summary 13
    linkedlist 33
    linux 2
    math 33
    poetry 4
    psychology 4
    python 3
    queue 7
    recursion 6
    remix 1
    segmenttree 1
    slidingwindow 6
    sorting 11
    spring 8
    spring-in-action 4
    sql 12
    stack 23
    string 36
    tool 12
    topological 3
    travel 1
    tree 12
    trie 10
    twopointers 10
    unionfind 9
    vscode 2
    warwick 5
    wittgenstein 3