betty1121的博客

Write a function that returns a random number within the range of [a, b] with equal probabilities.Note: you can use Java’s Random class.class Solution { public int random(int a, int b) { Random rand = new Random(); int i = a + rand.ne

Calculate the sum of all numbers in a Stack.Assumption: The Stack is not null or empty.Example:Stack contains 7,5,3,0Answer: 15class Solution { public int sumOfStack(Deque<Integer> stack) { int sum = stack.pop(); while (!s

Given a queue of integers, find the maximum number in it.Assumption: the queue is not null or empty.Example:Queue contains 5,8,3,2,7Answer: 8.class Solution { public int maxInQueue(Queue<Integer> queue) { int max = queue.poll();

Given an integerx, returntrueifxis palindrome integer.An integer is apalindromewhen it reads the same backward as forward. For example,121is palindrome while123is not.Example 1:Input: x = 121Output: trueExample 2:Input: x = -121...

Roman numerals are represented by seven different symbols:I,V,X,L,C,DandM.Symbol ValueI 1V 5X 10L 50C 100D 500M 1000For example,2is written asI...

Table:Patients+--------------+---------+| Column Name | Type |+--------------+---------+| patient_id | int || patient_name | varchar || conditions | varchar |+--------------+---------+patient_id is the primary key for this table.'co.

Table:Sales+--------------+---------+| Column Name | Type |+--------------+---------+| sale_id | int || product_name | varchar || sale_date | date |+--------------+---------+sale_id is the primary key for this table.Each row .

Table:Sessions+---------------------+---------+| Column Name | Type |+---------------------+---------+| session_id | int || duration | int |+---------------------+---------+session_id is the primary key for .

思路：原题只有exactly one 最大订单数量，group by之后用订单量降序排列，并limit取第一个值如果不止一个最大订单数，找出最大订单值，然后找出订单量等于这个值的就可以了。Query thecustomer_numberfrom theorderstable for the customer who has placed the largest number of orde...

Table:ActorDirector+-------------+---------+| Column Name | Type |+-------------+---------+| actor_id | int || director_id | int || timestamp | int |+-------------+---------+timestamp is the primary key column for this table..

Round() and isnull, round() can be used directly.In social network like Facebook or Twitter, people send friend requests and accept others’ requests as well. Now given two tables as below:Table:frie...

Table:Product+--------------+---------+| Column Name | Type |+--------------+---------+| product_id | int || product_name | varchar || unit_price | int |+--------------+---------+product_id is the primary key of this table.Tab.

Given an input string, reverse the string word by word.For example,Given s = "the sky is blue",return "blue is sky the".class Solution: """ @param: s: A string @return: A string """ ...

Given a string, determine if it is a palindrome, considering only alphanumeric characters and ignoring cases.Example"A man, a plan, a canal: Panama" is a palindrome."race a car" is not a palindrome.Ch...

Given an array of integers, remove the duplicate numbers in it.You should:Do it in place in the array.Move the unique numbers to the front of the array.Return the total number of the unique numbers.Ex...

Convert a linked list to an array list.ExampleGiven 1-&gt;2-&gt;3-&gt;null, return [1,2,3]class Solution: """ @param head: the head of linked list. @return: An integer list """ def...

Find a node with given value in a linked list. Return null if not exists.ExampleGiven 1-&gt;2-&gt;3 and value = 3, return the last node.Given 1-&gt;2-&gt;3 and value = 4, return null.class Solution: ...

Insert a node in a sorted linked list.ExampleGiven list = 1-&gt;4-&gt;6-&gt;8 and val = 5.Return 1-&gt;4-&gt;5-&gt;6-&gt;8.class Solution: """ @param head: The head of linked list. @param ...

495. Implement StackImplement a stack. You can use any data structure inside a stack except stack itself to implement it.class Stack: """ @param: x: An integer @return: nothing """ ...

Given a string containing just the characters '(', ')', '{', '}', '[' and ']', determine if the input string is valid.The brackets must close in the correct order, "()" and "()[]{}" are all valid bu...

172. Remove ElementGiven an array and a value, remove all occurrences of that value in place and return the new length.The order of elements can be changed, and the elements after the new length don't...