CircleUp 小公司 可以練練手
不熟悉front-end的Q3, 所以Fail
1. Palindromic Numbers
How many palindromic numbers [] are there in the set of numbers representable by a 16 bit unsigned integer [0..65535] ?
Send back both the number and the code you used to calculate it. You can use any programming language.
2. Cellular Automata
We will write a command-line console application that prints output that resembles a simple cellular automata.
Each line of the program’s output represents a row of 64 boolean values. True should be printed as an asterisk ( * ) and False should be printed as a hyphen ( - ). So each line of output should be 64 characters of asterisks or hyphens, followed by a newline. Use the following rules to determine the values in the rows: - The initial row of booleans should be all False, except for one True roughly in the middle (in the 32nd position; so it should be 31 Falses, followed by one True, followed by 32 Falses). Each subsequent row of booleans will depend on the one immediately before it. Each new row should be calculated using this rule: - The value for a given position in the new row should be True if in the previous row, either the position immediately to the left or immediately to the right was True, but not both. Otherwise it is False.
Print out 32 lines worth of output total using these rules. Include the output as well as the code.
3. Frontend / DOM Programming:
a. Create the following layout in HTML/CSS: (it’s a “C” for CircleUp with a green “glint” in the corner) White boxes are 100px by 100px, green box is 24px by 24px. Don’t worry too much about exact margins / sizing, but it should resemble the image.
b. Write jQuery / javascript so that clicking the large white boxes turns them blue (ignore the little green box). After the last one has been clicked, the green box should turn red and the blue boxes should start “undoing” their blu(18, 9, 'ABCDE'); insert into books (id, author_id, title) values (19, 10, 'ABCDE'); insert into books (id, author_id, title) values (20, 10, 'ABCDEF'); insert into books (id, author_id, title) values (21, 9, 'ABCDEF'); insert into books (id, author_id, title) values (22, 8, 'ABCDEF'); insert into books (id, author_id, title) values (23, 7, 'ABCDEF'); insert into books (id, author_id, title) values (24, 3, 'ABCD');
Copy/paste the above into , and then write a SQL query that will return: - ● author ID
- ● author first name
- ● author last name
- ● count of written books
For all authors with last name ‘Smith’. The results should include authors that have not written any books (with count “0”).
Send back the SQL or a link to sqlfiddle.
提供1, 3, 4解答
|