[output] | SELECT name FROM user WHERE id = <specific id> [instruction] | Write a SQL query that selects a specific name from user table. [input] | User table has columns (id, name, age)
[output] | DELETE FROM user WHERE user_id NOT IN (SELECT min(user_id) FROM user GROUP BY email) [instruction] | Create a SQL query to delete duplicates from a table and keep only one row. [input] | Table name: user Columns: user_id, email
[output] | int removeDuplicates(int *arr, int size) { int index = 0, i; for(i=0; i<size; i++) { if (arr[i] != arr[index]) { index++; arr[index] = arr[i]; } } return index + 1; } [instruction] | Write a function that takes an array and removes all duplicates in place, returning the length of the new array. [input] | [1, 2, 3, 2, 4, 3]
[output] | notspam [instruction] | Classifying whether an email is a spam or not. [input] | This email contains the message "Try our latest offers - discount up to 50%"
[output] | string s = "Hello World!"; reverse(s.begin(), s.end()); cout << s; // Outputs: !dlroW olleH [instruction] | Change this code to print the reversed version of a string. [input] | string s = "Hello World!";
[output] | bool isIsogram(string s) { int count[256] = {0}; int length = s.length(); for (int i=0; i<length; i++) { if (count[s[i]] == 0) count[s[i]]++; else return false; } return true; } [instruction] | Given a string s, determine if it is an isogram. [input] | "isogram"
[output] | def areAnagrams(s1, s2): if (len(s1) != len(s2)): return False s1 = sorted(s1) s2 = sorted(s2) for i in range(len(s1)): if (s1[i] != s2[i]): return False return True [instruction] | Write a code that checks if two String are anagrams. [input] | s1 = "listen", s2 = "silent"
[output] | class Point3D(object): def __init__(self, x, y, z): self.x = x self.y = y self.z = z def __repr__(self): return "Point3D(%d, %d, %d)" % (self.x, self.y, self.z) [instruction] | Create a class to represent a 3D point(x,y,z). [input] |
[output] | def isSorted(arr) : n = len(arr) for i in range(0,n-1): if arr[i] > arr[i+1]: return False return True [instruction] | Write a function to check if an array is sorted according to given constraints. [input] | arr = [2, 3, 15, 9, 5]
[output] | SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(str, ' ', n), ' ', -1) as word, COUNT(*) FROM ( SELECT SUBSTRING_INDEX(str, ' ', n) FROM (SELECT TRIM(BOTH ' ' FROM 'The quick brown fox jumps over the lazy dog') as str) t CROSS JOIN ( SELECT 0 AS n UNION ALL SELECT 1 AS n UNION ALL SELECT 2 AS n UNION ALL SEL [instruction] | Write a query that returns the word and the number of times it appears in the string. [input] | "The quick brown fox jumps over the lazy dog"
[output] | Using a Numpy array for a given task can potentially have a positive performance impact in terms of memory usage and computation speed. Numpy arrays are stored contiguously in memory, making them much faster to access than an array stored in traditional Python lists whose elements are stored separat [instruction] | Discuss the potential performance impacts of using a Numpy array for a given task [input] |
[output] | The syntax to get the ID would look like this: var table_id = $('#table').attr('id'); This code would retrieve the ID of the HTML element for the table by selecting the element with the id attribute equal to "table". [instruction] | An AJAX - jQuery request returns some HTML and requires an ID for the table. Provide an example of the syntax to get the ID. [input] |
[output] | Try...except blocks are used in Python to handle errors gracefully. They provide a way for Python to execute a code block and gracefully handle any errors that may occur. The code block inside the try is executed first and if an error occurs, it will be caught by the except block and handled. For ex [instruction] | How can we use try…except blocks in Python to handle errors? [input] |
[output] | The syntax to create an ArrayList in Java would be: ArrayList<dataType> listName = new ArrayList<dataType>(); Replace dataType with the appropriate type of data that needs to be stored in the list and listName with the desired name of the list. [instruction] | Create an ArrayList in Java [input] |
[output] | It is important to document each step of the code development process to ensure that all of the code is easily understandable and maintainable. Documentation can explain how the code works, which can be useful for other developers that may need to modify or debug the code. Additionally, it can expla [instruction] | Why is it important to document each step of the code development process? [input] |
[output] | The methods that could be used to implement a card game would include the following: - drawCard(): To retrieve a card from the deck. - shuffleDeck(): To mix up the cards in the deck. - getValue(): To get the numerical value of a card. - compareCards(): To compare two cards. - checkForWinner(): [instruction] | Design a series of methods that would be used to implement a card game [input] |
[output] | Content-based filtering is a method for recommending items to users based on the content of those items. It looks at the content associated with each item such as text, images, and videos and matches users with items that contain similar content. This type of filtering is based on the idea that user [instruction] | Summarize the concept of content-based filtering [input] |
[output] | def is_subset(a, b): for i in a: if i not in b: return False return True [instruction] | Compile a program to check whether an array is a subset of another array [input] | example1 = [4, 5, 6] example2 = [5, 6, 7]
[output] | function validateInput(field){ let input = field.value; let valid = /^[A-Za-z0-9_]*$/; if (!valid.test(input)) { alert("There is a character not accepted"); } } [instruction] | Develop a program for HTML input validation [input] |
[output] | a = 3 b = 5 c = 7 maximum = max(a, b, c) print("The maximum of three numbers is: ", maximum) [instruction] | Edit the following code to find the maximum of three numbers [input] | a = 3 b = 5 c = 7
[output] | def reverse(lst): return lst[::-1] lst = [1, 2, 3] print(reverse(lst)) [instruction] | Change the following code so that it can reverse a list without modifying the original list [input] | [1, 2, 3]
[output] | def count_digit(num, digit): count = 0 while num > 0: if num % 10 == digit: count += 1 num //= 10 return count Number = 1234 Digit = 3 print(count_digit(Number, Digit)) [instruction] | Compile a program to find the number of a specific digit in a given number. [input] | Number = 1234, Digit = 3
[output] | SELECT name, age FROM table ORDER BY age DESC; [instruction] | Create a SQL query to sort the following table by descending order of age. [input] | +----+--------+------+ | id | name | age | +----+--------+------+ | 1 | David | 21 | | 2 | Emily | 17 | | 3 | Rachel | 23 | | 4 | John | 12 | +----+--------+------+
[output] | SELECT name FROM table WHERE age > 18; [instruction] | Create a SQL query to find the names of all people who are older than 18 years of age. [input] | +----+--------+------+ | id | name | age | +----+--------+------+ | 1 | David | 21 | | 2 | Emily | 17 | | 3 | Rachel | 23 | | 4 | John | 12 | +----+--------+------+
[output] | https://www.website.com [instruction] | Extract the URL from the given text. [input] | The website can be accessed at https://www.website.com
[output] | [ 9, 7, 4, 3, 2, 1] [instruction] | Given a list, sort it in descending order without using the built-in sort function. [input] | list = [2, 7, 3, 4, 9, 1]
[output] | def swap(x, y): temp = x x = y y = temp return x, y [instruction] | Generate a function that swaps two given numbers. [input] |
[output] | def factorial(n): result = 1 for i in range(n): result = result * (i + 1) return result [instruction] | Rewrite the given recursive Python program as a loop. [input] | def factorial(n): if (n == 1): return n else: return n * factorial(n-1)
[output] | import java.util.List; List<String> list = List.of("1","2","3","4"); int sum = list.stream() .mapToInt(Integer::parseInt) .sum(); [instruction] | Rewrite the given code so that it uses Java 8 features. [input] | import java.util.ArrayList; List<String> list = new ArrayList<String>(); int sum = 0; for(String str: list){ sum += Integer.parseInt(str); }
[output] | Yes, the string matches the given regular expression pattern. [instruction] | Determine if the given string matches the given regular expression pattern. [input] | String: this is a sample string Pattern: (.*) sample (.*)