Tag:achievement

  • Reading notes the boundary of Growth-2: effective suggestions on learning methods

    Time:2021-12-11

    *** 1. “Agreeable” difficulty: in the learning process, there will always be some obstacles. In the short term, these obstacles make learning more challenging, make the learning process slower, and make learners depressed, but in the long run, they are beneficial. 2. “Generative effect”: learners must rely on their own efforts to continue learning in […]

  • Character pyramid

    Time:2021-12-7

    Common printing graphics programming problems Character pyramid List multiplication String splicing, fixed width centered Average height List generation Data type conversion Format output Higher order function reduce Digital triangle Unpacking list parameters Interview scoring Civil servants were graded on the spot during the interview. There are 7 examiners who input several groups of scores from […]

  • Average score and excellent statistics of hive’s basic operation

    Time:2021-10-10

    There is a set of grade data (student number; subject; grade) 1001 01 901001 02 901001 03 901002 01 851002 02 851002 03 701003 01 701003 02 701003 03 85 Start hive interactive mode and select the library [[email protected] ~]# hive hive (default)> use default; Build a transcript create table score( uid string, subject_id string, […]

  • Zset (ordered set) of redis’s five data types

    Time:2021-9-3

    On the basis of set, a value is added, set K1 V1, Zset K1 Score1 v1 127.0.0.1:6379 [1] > zadd myset 1 one # add a value (integer) 1 127.0.0.1:6379 [1] > zadd myset 2 two 3 # add multiple values (integer) 2 127.0.0.1:6379[1]> ZRANGE myset 0 -1 1) “one” 2) “two” 3) “three” 127.0.0.1:6379 […]

  • Informatics events

    Time:2021-8-14

    Tsinghua University and Peking University compete to admit them. What is the Informatics Olympiad_ Mobile Sohu Why are Tsinghua and Peking University competing for top students in informatics competition? You’ll know after reading it_ Mobile Sohu​m.sohu.co Remember this sentence: as long as you can enter the University, everything is easy to say How to win […]

  • [database] MySQL exercises and answers (educational administration management system)_ MySQL_ 5.7)

    Time:2021-7-28

    ✨ statement The answer to the exercise is not guaranteed to be completely correct, which is for reference only MySQL:5.7 Recommended software: Navicat premium Learning SQL statements requires diligent practice! ✨ Field description of each table course CId Course serial number, primary key PCId Prerequisite course DId Opening department number, foreign key CName Course name […]

  • Fifty SQL statements (MySQL version) problems

    Time:2021-7-17

    ————————–Table structure————————– Student (studid, studname, studage, studex) student table Teacher (TID, tname) teacher table course(CId,Cname,C_ TID) curriculum sc(SId,S_ CID, score) ———————————————————- Question 17: according to the average score from high to low, all students’ scores of “database”, “enterprise management” and “English” courses are displayed in the following forms: Student ID, database, enterprise management, English, number […]

  • Fifty SQL statements (MySQL version)

    Time:2021-7-5

    ————————–Table structure————————– Student (studid, studname, studage, studex) student table Teacher (TID, tname) teacher table course(CId,Cname,C_ TID) curriculum sc(SId,S_ CID, score) ———————————————————- Question 22: query the transcripts of students from the third to the sixth place in the following courses: business management (001), Marx (002), UML (003), database (004) format: [student ID], [student name], business management, […]

  • Java   Version of student performance management system, with source code!

    Time:2021-7-3

    preface For students majoring in computer science, they must be very impressed by the course design of student performance management system. Design, computer, coding, report writing, defense and a series of processes, although very simple, but we can also use some of our knowledge. Today, let’s review the following topic, using java se to realize […]

  • 50 SQL statements (MySQL version) problem analysis

    Time:2021-7-2

    ————————–Table structure————————– Student (studid, studname, studage, studex) student table Teacher (TID, tname) teacher table course(CId,Cname,C_ TID) curriculum sc(SId,S_ CID, score) ———————————————————- Question 25:Query the records of the top three scores of each subject (regardless of the juxtaposition of scores) SELECT * FROM (SELECT s1.S_CId,s1.Score,COUNT(DISTINCT s2.Score) Rank FROM sc AS s1 INNER JOIN sc AS s2 […]

  • C + + homework – score statistics

    Time:2021-6-28

    Achievement statistics 1) Write a function randscore to generate an integer of [0100] interval( Tip: use rand function) int randScore(){ int num = rand() % 101; return num; } 2) Write a function, using the above randscore function, randomly generate the results of a course for the whole class. void stuRandomScore(int stuScore[]){ for (int i […]

  • Group sorting function — row_ number()

    Time:2021-6-14

    1. MySQL 8.0 or above Usage 1: no grouping sort Row_ Number() over (order by field DESC)For example: row_ Number () over (order by DESC)All students are ranked from high to low, regardless of classUsage 2: Group sortROW_ Number () over (division by field 1 order by field 2 DESC)It means to group according to […]