precalculus exercises

Java exercises, how much you can do. http://bbs.csdn.net/topics/110067294 This is seen from CSDN. One every day. "Program 10" Title: A ball from the height of 100 meters free fall, each landing after the back of the original height of half, and then fell, to the 10th time when landing, the total number of meters. How high the 10th rebound. This topic, I will post two kinds of code. In fact, this topic, I am tired of simple calculation, want to make a

Introduction to the first chapter of the "AI" course exercises 1-1. What is AI. Try to explain from two aspects of discipline and ability. 1-2. In the development of artificial intelligence, what thoughts and thoughts played an important role. 1-3. Why can the machine (computer) imitate human intelligence. 1-4. What are the schools of artificial intelligence now? What are their cognitive perspectives. 1-5. What levels do you think should be studied on

data to write. The type can be a string, anarray, or a stream resource (as mentioned above). If data specified as a stream resource, the cached data stored in stream here is written to the specified file, which is similar to using the stream_copy_to_stream () function. The argument data can be an array (but not a multidimensional array), which is equivalent to file_put_contents ($filename, Join (", $array)). 　　flags 　　flagsThe value can be a c

student's school number, name and average score;Select Student.sid,student.sname,b.numname from (select Student_id,avg (num) as Numname from score GROUP by student_id HAVI NG AVG (num) >60) as Bleft JOIN student on B.student_id=student.sid4, inquiry all students of the school number, name, number of courses selected, total;SELECT Student_id,student.sname,count (course_id), SUM (num) from score left JOIN student on Score.student_id=student.sid GROUP by student_id5, inquire the surname "Li" the n

stored procedure that requires you to purchase, ship, and print a small ticket.In the absence of this goods and for the purchase, add this line of information;In the absence of this goods and for shipping, print without this cargo!The following starts the execution of the statement:Statement one: Incoming goods, number 1001 added 10Statement two: 1001 Goods shipped 5 unitsA small ticket is printed each time it is shipped and the quantity is sufficient.Statement three: The new arrival number is

BY degree DESC limit 0,143, inquiries and "Li June" with the gender of all students sname.Select sname from student where ssex= (select Ssex from student where Sname= ' Li June ')44, inquiries and "Li June" with the same sex and classmates sname.Select sname from student where ssex= (select Ssex from student where Sname= ' Li June ') and class= (select class from Student wher E sname= ' Li June ')45. Check the scores of all the "male" students who have enrolled in the "Introduction to Computer"

DATEDIFF (Year,sbirthday,getdate ())) as age from STUDENT--Query the maximum and minimum sbirthday date values in the student tableSELECT * FROM (select top 1 sname,sbirthday from STUDENT ORDER by Sbirthday DESC) a Union SELECT * FROM (select top 1 SNAME , Sbirthday from STUDENT order by Sbirthday ASC) b--Query all records in the student table in order of class number and age from large to smallSelect *,datediff (Year,sbirthday,getdate ()) as age from STUDENT order by CLASS Desc,sbirthday--Quer

= s2.id and s2.grade_id = S3.id GROUP BY s3.id ;3, the structure of the table is as follows:Books (book ISBN, book name, author number, publishing house, publication date);Author (author name, author number, age, gender);Requirements: use SQL to query the author's name, book name, and publisher of the age less than the average age. Analysis: The tables used are books and authors two tablesMethods: After combining the two tables, we found the information about AVG (age) less than the average age

1. On the premise that the environment variable is well configured, strike the command #>sqlplus2. Enter username/password Login Oracle #> default we use first, user name: Scott, password: Tiger login3.A. When you log in, you can only tap Sqlplus, enter your username/password at the prompt, or you can:#> Sqlplus/nolog#> Conn Scott/tigerB. If the Scott user is locked, it needs to be unlocked:#> alter user Scott account unlock;C. Want to see the current Scott users below a few tables, using the fo

show population in millions and GDP in billions both to 2 decimal places. Millions and Billions Divide by 1000000 (6 zeros) for Millions. Divide by 1000000000 (9 zeros) for billions.Select name,round(population/1000000,2 as population, Round(GDP/1000000000,2as fromwhere continent = ' South America '; 10. The name and GDP per capita of countries with at least 1 trillion (10 billion, 12 0) GDP. Rounds this value to the nearest 1000. The per capita GDP of trillion-dollar countries is shown to be

BY degree DESC limit 0,143, inquiries and "Li June" with the gender of all students sname.Select sname from student where ssex= (select Ssex from student where Sname= ' Li June ')44, inquiries and "Li June" with the same sex and classmates sname.Select sname from student where ssex= (select Ssex from student where Sname= ' Li June ') and class= (select class from Student wher E sname= ' Li June ')45. Check the scores of all the "male" students who have enrolled in the "Introduction to Computer"

, change the value of variables to change the results of SQL statement executionb Using bound variables, you can reduce the parsing of SQL statements and reduce the resources consumed by the database engine on SQL statement parsing.C uses bound variables to improve programming efficiency and reliability, reducing the number of accesses to the databaseD using bound variables, the query optimizer will estimate more real than the literal variablesParsing: Binding variables are relative text variabl

=score.stu_idGroup BY nameOrder by sum (grade) desc;Topic 11Calculate the average score for each accountMysql> Select Student.id,name,sex,brith,deparment,address,avg (Grade)From Student,score--Where student.id=score.stu_idGroup by ID;Topic 12Query student information for computers with a score of less than 95Mysql> SELECT * FROM student--Where ID in (Select stu_id from Scorewhere c_name= ' computer ' and gradeTopic 13Check student information for both computer and English examsMysql> SELECT * FR

. Query the maximum wage, minimum wage, number of persons for each job: department, maximum wage, minimum wage, number of persons (of which the highest wage, minimum wage, number of persons are grouped information) Table: EMP Condition: No grouping: Each salary is a group of information, the maximum wage is using Max (SAL), Minimum wage use min (sal), number of people using count (*)*/ SELECTJobMAX(SAL),MIN(SAL),COUNT(1) fromEmpGROUP byjob; /**********************************************/ /*16

place in all grades.SELECT * FROM (select RowNum p,t.score from (select S.score Score from SC s ORDER by score desc) t) TT where tt.p>1 and T T.p47. Inquire about the names of students who have not learned any of the courses taught by the "cotyledons" teacherSELECT DISTINCT SID from SC where SID is not in (select Sc.sid from Sc,course,teacher where Sc.cid=course.cid and course.tid=t Eacher.tid and Teacher.tname= ' Yang Weiwei ')48. Check the number of students with two or more failed courses an

10. Check the student number and course number of the highest score in the score table. (sub-query or sort)Select from where = (selectmax from score T)11. Check the average score of each course.12. Check the average score of the course with at least 5 students enrolled in the score table and begin with 3.Select avg from where inch (selectfromgroupby haveCount(1)>= 5and like'3%';13, the query score is greater than 70, less than 90 of the SNO column.14. Sname, CNO and degree columns for all stu

=650; "Src=" Http://s2.51cto.com/wyfs02/M00/8C/48/wKiom1hnzuPQQz5eAAHkbmJaH_M121.png-wh_500x0-wm_3 -wmp_4-s_3996861951.png "title=" 2016-12-31_232841.png "alt=" Wkiom1hnzupqqz5eaahkbmjah_m121.png-wh_50 "/>Note: the preg_match function is used for regular judgment if (!preg_match ($repat, $pass))The echo "password format is incorrect"else if ($pass! = $zaicipass) Determine if the password is consistent two times, if inconsistentecho "Two times password Inconsistent"The Header,die function works a

=650; "Src=" Http://s2.51cto.com/wyfs02/M00/8C/48/wKiom1hnzuPQQz5eAAHkbmJaH_M121.png-wh_500x0-wm_3 -wmp_4-s_3996861951.png "title=" 2016-12-31_232841.png "alt=" Wkiom1hnzupqqz5eaahkbmjah_m121.png-wh_50 "/>Note: the preg_match function is used for regular judgment if (!preg_match ($repat, $pass))The echo "password format is incorrect"else if ($pass! = $zaicipass) Determine if the password is consistent two times, if inconsistentecho "Two times password Inconsistent"The Header,die function works a

Dept d,emp E where E.deptno=d.deptno GROUP by Dname have avg (SAL) >2000; 8. Show departments and jobs for each department with a salary greater than 2500 per job Select deptno,job from EMP GROUP by Deptno,job have avg (SAL) >2500; 9. Show that the job name includes "man". And the average wage is more than 1000 of the job name and average wage Select Job,avg (SAL) from the EMP group by job has the AVG (SAL) >1000 and job like '%man% '; 10. Show the highest average wage in the department 11. Lis

d,emp E where E.deptno=d.deptno GROUP by Dname have avg (SAL) >2000;8. Show departments and jobs for each department with a average wage greater than 2500 per jobSelect deptno,job from EMP GROUP by Deptno,job have avg (SAL) >2500;9. Work name and average salary with "man" in the job name and average salary greater than 1000Select Job,avg (SAL) from the EMP group by job has the AVG (SAL) >1000 and job like '%man% ';10. Show the highest average wage in the department11. List of jobs with a minimu