Leetcode SQL 50

I picked a nice easy SQL one today, and it was far easier than I expected!

1757. Recyclable and Low Fat Products

The problem:

Write a solution to find the ids of products that are both low fat and recyclable.

Return the result table in any order. 

The solution:

select product_id from Products where low_fats = 'Y' and recyclable='Y';


Not much else to say, except I wish SQL was always this easy!



Comments

Post a Comment

Popular posts from this blog

Leetcode 75: 1768. Merge Strings Alternately

In this blog post, we'll examine a problem from Leetcode - "Merge Strings Alternately". We'll walk through a PHP solution and break it down for better understanding. The problem asks to merge two strings by adding letters in alternating order, starting with the first string. If one string is longer than the other, the additional letters should be appended to the end of the merged string. The PHP solution given below does exactly that: class Solution {     /**      * @param String $word1      * @param String $word2      * @return String      */     function mergeAlternately($word1, $word2) {         $word1Length = strlen($word1);         $word2Length = strlen($word2);         $output = '';         $remainder = '';         $loopLength = min($word1Length, $word2Length);         if ($word1Length > $word2Length) {             $remainder = substr($word1, $word2Length);         } else if ($word1Length < $word2Length) {             $remainder = substr($w
Read more

Defending Against Ettercap Attacks: A Brief Overview

  Ettercap, a popular and powerful suite of tools for network auditing and man-in-the-middle attacks, is one threat that consistently demands attention. This blog post will explore two scenarios where Ettercap attacks might occur and discuss how to effectively defend against and detect these intrusions. Scenario 1: ARP Poisoning One of the most common uses for Ettercap is ARP poisoning, a technique where the attacker manipulates the Address Resolution Protocol (ARP) to intercept data between two devices on a local area network (LAN). This allows the attacker to eavesdrop on or even alter communications. Defending Against ARP Poisoning: Static ARP entries: To prevent ARP poisoning, you can configure static ARP entries for critical devices. This ensures that their MAC addresses are not susceptible to manipulation. However, this method can be cumbersome in large networks. ARP monitoring tools: Implementing ARP monitoring tools like Arpwatch or XArp can help detect suspicious ARP activitie
Read more

Leetcode Two Sum Problem in three different languages

  The problem from Leetcode.com:  Given an array of integers nums and an integer target, return indices of the two numbers such that they add up to target. You may assume that each input would have exactly one solution, and you may not use the same element twice. You can return the answer in any order. Example: Input: nums = [2,7,11,15], target = 9  Output: [0,1]  Explanation: Because nums[0] + nums[1] == 9, we return [0, 1]. First, let's attack this using Python, and then we'll do the same with Java and compare the differences in the solutions. PYTHON Problem-solving: We can solve this problem by using a hash table in Python. First, we will iterate over the array nums and check if the difference between the target and the current element of nums exists in the hash table. If it does, we return the indices of the current element and the difference. Otherwise, we add the current element of nums and its index to the hash table. Steps: Initialize an empty hash table. Loop through t
Read more