Day68

알고리즘 코드카타

Customer Who Visited but Did Not Make Any Transactions

select a.customer_id, count(a.visit_id) as count_no_trans 
from Visits a 
left join Transactions b
on a.visit_id = b.visit_id 
where b.transaction_id is null
group by a.customer_id 
;

카드 뭉치

class Solution {
    public String solution(String[] cards1, String[] cards2, String[] goal) {
        int i = 0;
        int j = 0;

        for (String card : goal){
            boolean flag = false;

            if(i<cards1.length){
                if(cards1[i].equals(card)) {
                    i++;
                    flag = true;
                }
            }
            if(j<cards2.length){
                if(cards2[j].equals(card)) {
                    j++;
                    flag = true;

                }
            }
            if(!flag) {
                return "No";
            }
        }
        return "Yes";
    }
}