Sandbox::https://github.com/seshireddy/Leetcode/blob/master/database/

Repository navigation

-- Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything.

-- Table: Customers.

-- +----+-------+

-- | Id | Name |

-- +----+-------+

-- | 1 | Joe |

-- | 2 | Henry |

-- | 3 | Sam |

-- | 4 | Max |

-- +----+-------+

-- Table: Orders.

-- +----+------------+

-- | Id | CustomerId |

-- +----+------------+

-- | 1 | 3 |

-- | 2 | 1 |

-- +----+------------+

-- Using the above tables as example, return the following:

-- +-----------+

-- | Customers |

-- +-----------+

-- | Henry |

-- | Max |

-- +-----------+

select Name as Customers from Customers left join Orders on Customers.Id = Orders.CustomerId where Orders.CustomerId is Null;

Navigation Menu

Repository navigation

_183.sql

_183.sql

FilesExpand file tree

_183.sql

Latest commit

History

_183.sql

File metadata and controls